Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using the expression below on a line chart that includes a month filter as the chart shows data on a monthly basis
Avg(if(Year>=2016,value))
Using the same expression I want to be able to ignore the month filter.
I have previously used set analysis Avg({$<Month=>},value) to ignore the month filter but I'm not sure how to add the if statement
Thanks for your assistance
Regards,
Andy
Hi Youssef,
I used your expression as follows and it worked, thanks
Avg({$<Month=>}if(Year>=2016,value ))
Hi,
try this:
Avg({<Year=>}if(Year>=2016,value))
Hi Youssef,
I used your expression as follows and it worked, thanks
Avg({$<Month=>}if(Year>=2016,value ))
I guess this will solve it:
Avg ({<Month=>}If (Year>=2016,value))
Cheers
Too late...
Sorry!