Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have $TrendDate named variable, which im trying to use to filter a chart by date. Heres an example to what value I set the variable:
=>Date(Today()-7)<=Date(Today()) - which would mean select a weeks date range right? How ever, I get an expression error stating
"Garbage after expression 'Date'" here. What kind of syntax should I use here?
Here is how I use the variable in the chart expression:
Avg({$<Date={'$(TrendDate)'}>}[#Value])
// Tuomas
Try the variable like this
='>' & Date(Today()-7) & '<=' & Date(Today())