Forum Discussion
dana1
9 years agoFrequent Visitor
RANK&CALCULATE SOS!
Hey,
, everything I've tried so far does not work :(
I have a table that contains the customer calls to the call center.
Each customer has an institutions ID so you can see from which institute he is contacting us.
I need to count the number of calls for each institute in 2016 and then rank the institute,
so that only the 120 institutions with the most calls to the call center will be shown.
The next step, is to present the amount of calls in 2017 of the same 120 institutions (i need to compare 2 years)
The next step is to calculate the target-
X = the number of calls of 120 institutions with the most calls for 2016
Y = the number of calls of the same 120 institutions in 2017
(X-(X*0.2))/Y
I managed to produce all of these in the table,
but I need to present a KPI visual which will show me only the calulation
I've been dealing with it for over a week and I can not find a solution. Really needs help!
4 Replies
- VvelardeCommunity Champion
- v-yulgu-msftMicrosoft Employee
Hi dana1,
From above image, it looks like you have received desired result returned by (X-(X*0.2))/Y for each instituteID. So, what did you mean "I need to present a KPI visual which will show me only the calulation"? How do you want to display value on KPI? Could you please illustrate your requirement with an example?
Regards,
Yuliana Gu- dana1Frequent Visitor
I solved the problem! thanks anyway :)- v-yulgu-msftMicrosoft Employee
Hi dana1,
Glad to hear that you have resolved it. Would you please kindly share your solution with us? And Please kindly mark it as an answer so that others having similar problem can find the solution more easily.
Regards,
Yuliana Gu