Tickets (with diff. reasons) for products

[Anonymous]

hey everybody,

i've more or less 30 different products. Customers are allowed to write tickets for each product whenever Problems emerge.

These tickets consist out of different reasons.

I want to show that for example product A caused 1000 tickets, wheareas  the table should Display whole tickets for the product and number of tickets for the 3 most important reasons (in % relation to the whole thickets of the product!

May you have any ideas?!

It should look somehow like the table below, but there should be a column for the 1. , 2. and 3. largest reason! and the % should be calculated  by each product instead over all products!

[#2]

Hi,

Try this exression,

Sum( aggr(if( rank(Count(Reason), Product, Reason)<=3,Count(Reason)), Product, Reason)) / Sum(Total<Product>  aggr( Count(Reason), Product, Reason))