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% |
