topic add condition in set analysis? in App Development

add condition in set analysis?

gauravgg — Thu, 15 Dec 2016 12:14:13 GMT

I have the following expression for top 10 Customers

count({<[Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])

I want to add the following two condition in expression

1) Customer_type=Customer

2) WildMatch(GROUP,'*operations*')=1

Thanks in advance.

Re: add condition in set analysis?

Gysbert_Wassenaar — Thu, 15 Dec 2016 12:18:54 GMT

Perhaps this does what you want:

count({<[Customer_type]={'Customer'},GROUP={'*operations*'} [Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])

Re: add condition in set analysis?

sunny_talwar — Thu, 15 Dec 2016 12:24:04 GMT

or this:

Count({<[Customer_type]={'Customer'},GROUP={'*operations*'}, [Customer Name]={"=Rank(Count(TOTAL <[Customer Name]> {<[Customer_type]={'Customer'},GROUP={'*operations*'}>} [Ticket No]))<=10"}>} [Ticket No])