Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
2.Hi Folks,
I have a Type Filter (Type1, Type2, Type3)
I want to show 3 kpi's for each type
i write the expression as below given,
Count({<Type={"Type 3 "}>}Ticket)
It was showing count, when i want select the Type2 - Type2 only show the value, others are blank.
1. default also i want to show the value
2. If select a particular Type its should the value based on Type, others should be zero.
How to show others are blank
Regards,
Sub2u444
Try the intersection operator *
Count({<Type *= {"Type 3 "}>}Ticket)
You can also do this:
If(Type = 'Type 3 ', Count({<Type={'Type 3 '}>}Ticket), 0)
or this if you can have more then one selected at a time
If(SubStringCount(Concat(DISTINCT Type, '|'), 'Type 3 ') = 1, Count({<Type={'Type 3 '}>}Ticket), 0)
Hi,
Thanks for the reply, it was working.
Instead of 0, i want to show null/blank value...
Can you try this:
If(SubStringCount(Concat(DISTINCT Type, '|'), 'Type 3 ') = 1, Count({<Type={'Type 3 '}>}Ticket))
Maybe like
If( Count({<Type *= {"Type 3 "}>}Ticket) > 0, Count({<Type *= {"Type 3 "}>}Ticket), '')
@Swuehl,Sunny-Thanks for the reply and thank you so much for your support