13 Replies Latest reply: Dec 4, 2014 10:08 AM by Marcus Sommer RSS

    Table: Day - 7 figures issue

    Aymeric MARTIN

      Hello,

       

      I am struggling with a simple issue.

      A table has a date as dimension and a value as expression. I would like to add an expression showing this value for the "day-7".

       

      Trying this is not working:

      sum({<date={"$(=date(max(date)-7))"}>}value)

      Using "above" function is not the right solution as it will not work for the 6 first rows of my table.

       

      Attached is an example. Does someone have the solution to this?

       

      Thanks in advance