Zoho Analytics - SQL query requirement
- or -
Post a project like this1652
£33/hr(approx. $41/hr)
- Posted:
- Proposals: 4
- Remote
- #2552004
- Awarded
Description
Experience Level: Expert
We have two tables in Zoho Analytics: "Targets" and "Journals"
The Targets table has a Date column, with dates for each day of our financial year, and a Sales column.
The Journals table has a Journal Date column, a column for Net Amount, and a column for Account Name. In the Journals table, there are multiple rows containing transaction data, where the Date column may contain the same date (because we post many journal transactions on one day)
We require a SQL query in Zoho Analytics to:
> Join the Journals table to the Targets table, on the Targets.Date field, so that the query only returns one distinct day
> Filter the Journal table where Journals.Account Name = Sales
> Sum Journals.Net Amount, against each distinct day from the Targets.Date field
The Targets table has a Date column, with dates for each day of our financial year, and a Sales column.
The Journals table has a Journal Date column, a column for Net Amount, and a column for Account Name. In the Journals table, there are multiple rows containing transaction data, where the Date column may contain the same date (because we post many journal transactions on one day)
We require a SQL query in Zoho Analytics to:
> Join the Journals table to the Targets table, on the Targets.Date field, so that the query only returns one distinct day
> Filter the Journal table where Journals.Account Name = Sales
> Sum Journals.Net Amount, against each distinct day from the Targets.Date field
Joe M.
100% (12)Projects Completed
13
Freelancers worked with
12
Projects awarded
45%
Last project
14 Sep 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies