9 Replies Latest reply: May 28, 2015 7:26 AM by Michael Tarallo RSS

    how to show data of last 7 days in bar chart



      I have an order table with a field OrderDate, a field Units and a field Price.

      I created a bar chart and used OrderDate as dimension and sum(Units*Price) as measure.


      The bar chart now shows all the order dates and the sum of Unit*Price for each day.


      What I want to achieve is, that the bar chart only shows the last 7 days before today.


      What is the best way to achieve this?