If I use Reporting Calendar or Transaction Calender as the dimension it works fine but what I want to do is flip this based on a user selection.
In essence you want to let the user choose which calendar to use?
Ok, there's an extension called qsVariable avaible. You can use that to create a variable and a set of values for the variable. You can display these values as buttons. And use the variable in a calculated dimension in your chart. Something like =pick(match(vCalendar, 'Transaction', 'Claims'), [%TrnYYYYMM],[%ClaimYYYYMM])
Thanks Gus. I'm already using that to set variables in my dashboard. Working nicely to set the vReportingPeriod.
I can swap the measure based on Transaction or claims and works a treat for bar guages but my charts use the calendar as a dimension.
I see where my issue is now. I'm building my calendar dimension as a Master Item as I made it a drill down from quarter to month.
If you use Master items in this way you cannot reference in an expressions yet. I guess I have to decide which is the best feature to have drill down to month from quarter or being able to switch reporting views.
As a follow on question would you us pick(match..... of If(..... they seem to do the same thing. Is it a question performance as to which method to use?
You're welcome Annie.
A pick-match combination will perform better than deeply nested if's. With if statements every branch is always evaluated. You won't see any difference with only a few simple nested if statements, but with a lot of nested if's performance can bog down. A pick-match could improve things in such situations.