Hello Team,
Based on the sample table below, I need to know the percentile based on the Call Type and # of calls handled per date.
Wherein:
Call Type %: # calls/Total Calls per day
ID # | Date | Call Type | # of Calls | Call Type % |
A1 | 5/1/2024 | Restaurant | 5 | 71% |
A1 | 5/1/2024 | Hotel | 2 | 29% |
B2 | 5/2/2024 | Restaurant | 3 | 17% |
B2 | 5/2/2024 | Hotel | 7 | 39% |
B2 | 5/2/2024 | Delivery | 8 | 44% |
Solved! Go to Solution.
@rjesus1987 one way of doing this