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

    Dirk Weber

      Hi,

       

      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?