I want to display this data in a chart, for each month.I used 'num(Month(Date)) as Month' to get the month for each record. However, when i use this month as dimension, it only shows the records which have only one record in a month.
I know I should use an aggregation, cause there are more records in that month, but which one can I use to not get wrong data? So let's say only the latest date?
If i use Sum() I will get a not accurate display of data.