Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help me out correcting my stacked bar chart,
I want to calculate for each of the each Agent, the Top 5 services based on the number of tickets they resolved.
But the problem is that seem good but every time I select one agent the Top 5 change, the pourcentages change ... so it's not correct maybe I have to make a set analysis with Sum( Aggr( If(Rank ...
( btw I filtered my graph on a perimeter because there are a lot of agents and I am afraid that it is not very readable)
Thanks,
Y
Hi @youss123 , maybe you can omit the filter by Agent?
count( distinct {<Statut ={"Resolved"} , Agent>} [%Key - Ticket])
JG
Hi,
Thank you for your comment,
There is still a problem is that if for example if an agent contributes in only one service, normally the percentage should be 100%, here it is not, so I think the whole expression is wrong.
Y
Hi @youss123, it is difficult to understand the details with no sample data. Maybe is something like:
count( distinct {<Statut ={"Resolved"} , Agent>} [%Key - Ticket]) / count( distinct {<Statut ={"Resolved"} , Agent>} TOTAL <Agent> [%Key - Ticket])
But it is just a try without understanding the real problem.
JG