In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Percentile Value

rjesus1987
6 - Meteoroid
‎05-15-2024 12:36 PM

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 #DateCall Type# of CallsCall Type %
A15/1/2024Restaurant571%
A15/1/2024Hotel229%
B25/2/2024Restaurant317%
B25/2/2024Hotel739%
B25/2/2024Delivery844%
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
binu_acs
21 - Polaris
‎05-15-2024 02:51 PM

@rjesus1987 one way of doing this

image.png

PErcentile_15052024.yxmd
Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All