9 Replies Latest reply: Apr 20, 2017 9:07 AM by Beck Bakytbek RSS

    Monthly Bar Chart for weekly updated incremental table

    Edil Turdumambetov

      Hi Everyone,


      I have a problem with building a bar chart.

      In my system the table is updated weekly on the status of every row in the table - I am kind of creating a screen shot of a table for that particular week. I need to create a bar chart that shows monthly values of Sales. the date of the data load is stored in a field called _loadedOn.


      My current approach:

      Dimension: MonthName(_loadedOn)

      Measure: Sum(Sales)


           The problem with this approach is that it sums up all the weeks within a month and gives a huge value. What is preferable instead is summing only the latest week in a month.


      Any ideas on how to tackle this?