Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 filter and two KPI chart.
1. First filter of alternate state as "inherited" is Common for both the KPI chart.
2. Second filter is dedicated to 1st Kpi chart of alternate state as State1.
3. Third filter is dedicated to 2nd kpi chart of alternate state as State2
And a KPI chart of expression: Count(distinct TicketID)
How do I brinng
1.both 1st filter and 2nd filter selection in 1st kpi chart
2.both 1st filter and 3rd filter selection in 2nd kpi chart
And most importantly
no association is happening between filters.
How can I achieve this???
@Michael Tarello
*BUMP* - Can someone please look at this?
KPI # 1:
Count({$* State1}distinct TicketID)
KPI #2:
Count({$* State2}distinct TicketID)
Assumptions:
1. The first filter is inheriting the default state
2. You want to count the TicketIDs that are present in both States as opposed to counting those that are present in either (if you want the later then you would use ' + ' as the set operator between the states rather than the ' * ' )