37 Replies Latest reply: Sep 3, 2013 5:36 AM by Thomas Jensen RSS

    Dynamic last 15 days

      Hello,

       

      I have a line chart where i have:

       

      Date as dimension

       

      Expression as:

      =sum({<Date_Clean={'$(vLast15Days)'}>} TotalPrice)

       

      This gives me from today and 15 days back.

       

      What if i want to make this dynamic, so if i select the 27 of august, it shows me 27 of august and 15days back.

       

      Now its just static and i cannot select a date back in time.

       

      I have these listboxed to choose:

      Month, Year, Day