Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with an expression that calculated Average Survey Answers over a selected period of time (months). I have to add another expression to do the same calculation - Average Survey Answers, but for the last month from the selected months. So for example if I select Apr, May, Jun and July I want my second expression to display the results for July only, as July is the last month is my selection. My expression is based on a variable called. Any ideas? I cannot post the dashboard as it's client work...
Katarzyna,
See a generic idea in the attached. I'm using set analysis comparing Month with the max(Month).
Regards,
Michael
Katarzyna,
See a generic idea in the attached. I'm using set analysis comparing Month with the max(Month).
Regards,
Michael
Thank you Michael, that worked!