0 Replies Latest reply: Apr 19, 2017 10:14 AM by Edil Turdumambetov RSS

    Monthly Data with Weekly Incremental Update

    Edil Turdumambetov

      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