Different selections on one page

[Kirsten]

I want to have different filters active per graph on one page. If you use alternate states the complete graph becomes inactive for selection, but I would like to have 1 filter active on one graph and another filter active on another page

See attachment for example. I have hidden the names and numbers due to confidentiality

[Rodj · Accepted solution]

Hi Kirsten,

If I understand you correctly you could potentially use use set analysis to achieve what you are after. For example, if you used something like:

sum({1 <YearMonth = {"*"}>} Defects)

This would give you the sum of all Defects across all of the data for all values of YearMonth.

I'm not clear on what selections you want applying to which charts but in general set analysis will give you the ability to determine which dimension values you want to include or exclude from a chart regardless of selections. Hope that sets you in the right direction.

Rod

[Kirsten]

Thanks that works. What does the code look like of you would like to have multiple selections active?

Is it something like this?

sum({1 <YearMonth, PPG= {"*"}>} Defects)

[Rodj · Accepted solution]

Sort of, everything in the < > is called the "set modifier". We are modifying the set, in this case the set of all values (i.e. {1}). So you can put anything in the set modifier that determines a set of values that you have in your app. for your YearMonth you'd have to specify a value or group of values. The online help has heaps of examples. Basically you are determining the set of values that you want the aggregation to be applied to.

[Kirsten]

Thanks