Create SQL reports in Zoho Analytics
€100-120 EUR
Dibayar saat pengiriman
MAKE 5 REPORTS SQL IN ZOHO ANALYTICS, ONE DASHBOARD AND 5 WIDGETS
Tables to use:
Invoices
Invoice Items
Customers
Credit notes
DONNEES MANDATAIRE
ACHAT ANNONCES OK
Columns in the 5 reports:
[login to view URL] Date
[login to view URL] number
[login to view URL] order
[login to view URL] D'ORIGINE
[login to view URL] name
Invoice [login to view URL] total (BCY)
[login to view URL] DU JOURNAL
ACHAT ANNONCES [login to view URL] du lignage
ACHAT ANNONCES [login to view URL] de rétrocession du journal extérieur
DONNEES [login to view URL] du mandataire
DONNEES [login to view URL] de rétrocession
Credit [login to view URL] Note Number
Credit [login to view URL] Total (BCY)
[login to view URL]
Make 5 reports different with these columns according to some filters in order to calculate 5 aggregate formulas (the result must be used in other reports):
I-Rapport d'export (non Malcom):
User Filters:
”[login to view URL] D'ORIGINE” (multisélection)
”[login to view URL] DU JOURNAL” (multiselection)
Filters
“[login to view URL]”: closed
“[login to view URL] des instances”: non payé
"ACHAT ANNONCES OK"."Montant du lignage": not empty
Invoice [login to view URL] of the article: contains “LIGNAGE”
[login to view URL] DE FACTURE: is Annonce légale
Agregate formula: "Produit net d'exploitation journaux extérieurs" (The data "Produit net d'exploitation journaux extérieurs" calculated from this formula must be used in other reports).:
"Invoice [login to view URL] total (BCY)" - "Credit [login to view URL] Total (BCY)" - "ACHAT ANNONCES [login to view URL] du lignage" + ("ACHAT ANNONCES [login to view URL] du lignage" * "DONNEES [login to view URL] de rétrocession" / 100)
II-Rapport d'export (MALCOM):
User Filters:
[login to view URL] D'ORIGINE (multisélection)
[login to view URL] DU JOURNAL (multiselection)
Filters
[login to view URL]: closed
“[login to view URL] des instances”: non payé
Invoice [login to view URL] of the article: contains “LIGNAGE”
[login to view URL] DE FACTURE: is “Annonce légale”
Agregate formula: "Produit net d'exploitation export MALCOM" (The data "Produit net d'exploitation export MALCOM" calculated from this formula must be used in other reports).:
(("Invoice [login to view URL] total (BCY)"- Credit [login to view URL] Total (BCY)) *30/100
III-Rapport journal de l’instance
User Filters:
[login to view URL] D'ORIGINE (multisélection)
[login to view URL] DU JOURNAL (multiselection)
Filters
[login to view URL]: closed
“[login to view URL] des instances”: non payé
Invoice [login to view URL] of the article: contains “LIGNAGE”
[login to view URL] DE FACTURE: is Annonce légale
Agregate formula: "Produit net d'exploitation journal de l’instance" (The data "Produit net d'exploitation journal de l’instance" calculated from this formula must be used in other reports).:
"Invoice [login to view URL] total (BCY)" - Credit [login to view URL] Total (BCY)
IV-Rapport d’import depuis instances non MALCOM:
User Filters:
[login to view URL] D'ORIGINE (multisélection)
[login to view URL] DU JOURNAL (multiselection)
Filters
[login to view URL]: closed
“[login to view URL] des instances”: non payé
Invoice [login to view URL] of the article: contains “LIGNAGE”
[login to view URL] DE FACTURE: is Annonce légale
Agregate formula: "Produit net d'exploitation importé depuis instances non MALCOM" (The data "Produit net d'exploitation inter instance" calculated from this formula must be used in other reports).:
(Invoice [login to view URL] total (BCY) - Credit [login to view URL] Total (BCY)) * 60/100
V-Rapport d’import depuis instance MALCOM:
User Filters:
[login to view URL] D'ORIGINE (multisélection)
[login to view URL] DU JOURNAL (multiselection)
Filters
[login to view URL]: closed
“[login to view URL] des instances”: non payé
Invoice [login to view URL] of the article: contains “LIGNAGE”
[login to view URL] DE FACTURE: is Annonce légale
Agregate formula: "Produit net d'exploitation importé depuis MALCOM" (The data "Produit net d'exploitation envoyé par MALCOM" calculated from this formula must be used in other reports).:
(Invoice [login to view URL] total (BCY) - Credit [login to view URL] Total (BCY))
VI-Create one Dashboards with these 5 reports.
User filters:
“[login to view URL] D'ORIGINE” (multiselection)
“[login to view URL] of invoice” (multiselection =>quarters and years)
In this dashboard, create five widgets for the five reports with one figure in each: calculate SUM for the quarter of all Produit net d’exploitation XXXXX you calculate before. (see picture and PDF in attached file)
ID Proyek: #37221211
Tentang proyek
Diberikan kepada:
Hi Francois! With my experience of 5-6 years in implementing zoho one for my clients. Zoho analytics and sql query table has become one of my strongholds. I can complete this project in a short time efficiently and pr Lebih banyak
5 freelancer rata-rata menawar €200 untuk pekerjaan ini
I am expert in zoho analytics and other zoho apps.....................I can help you with this.............Connect to me in chats...........
[✔] .NET EXPERT: You have received a 30% discount (€60) on Project 'Create SQL reports in Zoho Analytics'. (Recently finished a comparable work) - As a result, you should expect better outcomes in a shorter period (3 d Lebih banyak
