How to use date diff in set analysis

[Sundeep]

Hi,

I have data like below

username value date
Name1        1         2019-04-01
Name2        2         2019-04-02
Name3        3         2019-04-03
.
.
.
Name16      16       2019-04-16

I want to show data in my line graph from Max(Date)-7.

Please note that every day new data will come so I need max date.

Currently I am writing formula as Avg({$date={">$(=Max(date)-7)"}>}value)

but its not working and giving error as "The chart is not displayed because it contains only undefined values."

[benedettitatian]

Try this:

SUM({<date={">=$(=date(Max(date)-7,'YYYY-MM-DD'))"}>} value)

[Sundeep]

Hi,

Tried but result is same. Getting the same error

Thanks

[jonathandienst]

Are your dates proper numeric date Values or strings? If they are strings, convert them to numeric dates using Date#(). Also correct the syntax of your expression ('<' added):

 Avg({<date={">$(=Max(date)-7)"}>} value)

[Sundeep]

I made the changes but still its not working. Giving me the same error