Percentile Value

[rjesus1987]

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%

[binuacs · Accepted solution]

@rjesus1987 one way of doing this