Aggregate value for 7 days after date selected

[Anonymous]

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

[settu_periasamy]

May be try

=sum( {<DATE={'>=$(=DATE)<=$(=Date(DATE+7))'}>} [Nº OF DOWNLOADS])

[sunny_talwar]

Not sure how the environmental variables are set, I would just suggest one change:

=Sum({<DATE={'>=$(=Date(Max(DATE), 'YYYY-MM-DD'))<=$(=Date(Max(DATE)+7, 'YYYY-MM-DD'))'}>} [Nº OF DOWNLOADS])

[Anonymous]

This expression only give me the value from selected day.

[sunny_talwar]

Are you making selection in DATE field? or is there another field you are making selection in?

[Anonymous]

Yes, i only have a data field to make selection. 

Example:

A DATA filter and a table with DATA, NAME of PRODUCT and N OF DOWNLOADS.

[Anonymous]

Sorry DATA means DATE