I have a gauge which I want to show for a subset of my data defined by selecting certain values from two particular fields. I am using set analysis for the first subset which enables me to select data where a particular condition is met but I can't work out how to select the second subset.
So: I have a target for numbers of students which is dependent on where they come from - either the EU or outside the EU. I want a gauge for each target. I want the pointer to show for that gauge (i.e. for those from the EU only) the numbers with an appropriate status (i.e. that they have applied and been accepted). So I have this initially:
where Application Statuses of U/F and C/F mean the students have accepted their offers. So I need to include somewhere in this statement the Location field which would be [Residency Desc]='EU' for the EU target (for example) otherwise I get the same value for both gauges.
Can I do this by nesting the set analysis? Or can I use aggr? Because I want to set conditions on both fields I am having trouble!