
1. Re: Selecting dynamic measures into a calculated field on a dashboard
Alan Kwan Jun 7, 2013 9:43 AM (in response to Alan Kwan)Hi Shawn Wallwork,
What do you suggest? I don't think there is a way to have the user multiselect a parameter to decide who goes onto the numerator and denominator. One really stupid way I can think of is, creating multiple parameters for each field in the calculated field, and have the parameter value be true/false. For example:
%Occupancy: [Parameter 1] + [Parameter 2] + ,,, / [Parameter 1] + [Parameter 2] + ....
CASE [parameter1] when TRUE then sum(Duration) ELSE 0
Hope this makes sense, and hope there is an easier way.
Thanks,
Alan

2. Re: Selecting dynamic measures into a calculated field on a dashboard
Jonathan Drummey Jun 8, 2013 6:55 PM (in response to Alan Kwan)How about you flip it around? Set up a parameter with the different combinations of numerator/denominator, then set up a measure driven by CASE statement that returns the right values.
e.g.
CASE [your parameter]
WHEN "talking per state" THEN ...equation...
WHEN "talking + email" THEN ...equation...
...other statements...
END
An advantage to this is that you have a single parameter that you can then use in building worksheet titles, tooltips, etc.
Jonathan