Set Analysis within IF statement also using Alternative States

[#1]

=IF(aggr(minstring({[End]< KPIType = {'Status'} >} KPIStatus),OrgID)

='Engaged','1.StatusSame','3.StatusDown')

Hi

Hopefully a simple query, i'm trying to figure out where how I add set analysis into the above If statement to ignore certain fields if selected. - can any one give me any pointers please?

thanks in advance

H

[sunny_talwar]

This seems like a calculated dimension, do you have to ignore selections in dimensions or do you want to ignore them in your expression so that you chart doesn't change based on selections

[#3]

Hi Sunny,

Yes it is actually part of a larger nested If statement that creates a calculated dimension.

I would like the chart to ignore certain selections only.

So, for example, I would like the chart to change if Country = England were selected but not if anything from Promotion  were selected.

Kind regards

H

[sunny_talwar]

What is your expression/s?

[#5]

count(distinct OrgId)

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT {<Promotion>} OrgId)

[#7]

Perfect Sunny, thank you!