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?

      Thanks.

      Edil