Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting show an average for the last 90 days in a chart. I have tried the expression Avg({$<DateNeo={">$(=Today() - 90)"}>} Result), but it returns no results. If I change the greater than symbol to an equal symbol, as in Avg({$<DateNeo={"=$(=Today() - 90)"}>} Result), it returns back a result.
What needs to be changed to allow this to work?
{$<DateNeo={">$(=Date(Today() - 90))"}>}
HIC
Thank you! I would not have thought there would be a need to convert to date.