Closed
Report Definition Joins
Hi, currently we are having a problem figuring out how to use reports to display the data we have captured.
Data is captured in the following format.
ID - Date - Click - View
123 - 20180301 - 10 - 20
123 - 20180302 - 30 - 40
456 - 20180301 - 10 - 15
789 - 20180302 - 20 - 30
We want to display it in the following format.
ID - Total Click Last 2 Days -Total View Last 2 Days
123 - 40 - 60
789 - 20 - 30
456 - 10 - 15
How would we go about doing this with reports?
***Updated by moderator: Lochan to add Categories***
Posted: 6 years ago
Toyota Financial Services
Toyota Financial Services
AU
Hi,
In the Query tab of the report definition add column name ID, Date, Click and View and choose summarize as "Sum" for Click and View Columns. At the end of the query tab Display, select "For Each Group" based on "ID".
Thanks
Sandeep P V