7 Replies Latest reply: Jul 6, 2016 4:24 AM by Pedro Lopes RSS

    Aggregate value for 7 days after date selected

    Pedro Lopes

      Hi guys,

       

      I have information about about nº of downloads by date. On my Dashboard i have a table with DATE and Nº OF DOWNLOADS, and i have a filter DATE too.

       

      My question is. It is possible create a expression too wen i select some date, my output be the aggregation from Nº OF DOWNLOADS 7 days  starting DATE selected.

       

      Exemple:

       

      I select date '2016-06-05' and the output is


      sum( {<DATE={'2016-06-05'+'2016-06-06'+.........+'2016-06-07'}>} Nº OF DOWNLOADS)

       

      Thanks in advance,

       

      Pedro Lopes