Need you ideas and help on below.
I have a weekly updated table. And there is a field called _loadedOn which captures the date when the data was, well, loaded.
Now the task is to create a bar chart, where the dimension should be months and measure should be the sum of Sales.
when i do:
MonthName(_loadedOn) as dimension and
sum(Sales) as the measure
The bar chart shows the months as it should, but the measure sums up all weeks Sales together. In my case I would like to have the last week's data of a particular month to be presented in the graph.
What approach should I follow, any ideas?