Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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
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
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
What is your expression/s?
count(distinct OrgId)
Try this
Count(DISTINCT {<Promotion>} OrgId)
Perfect Sunny, thank you!