Monthly Data with Weekly Incremental Update

Anonymous — Wed, 19 Apr 2017 14:14:18 GMT

Hi Everyone,

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?

Thanks all.

Edil

topic Monthly Data with Weekly Incremental Update in App Development

Monthly Data with Weekly Incremental Update