Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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."
Try this:
SUM({<date={">=$(=date(Max(date)-7,'YYYY-MM-DD'))"}>} value)
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)
I made the changes but still its not working. Giving me the same error