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.




      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