Obtain deciles in one function or tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I know that I can use the "Summarize" tool to get a percentile. However, what if I want the deciles? I don't want to apply the Percentile function within the Summarize tool 10 times and enter the percentage rank each time. I want one function or one tool that will provide the deciles (or any arbitrary set of evenly divided percentiles).
Is this possible in Alteryx?
By deciles, I mean the 10th percentile, 20th percentile, ... , 90th percentile, and 100th percentile.
Solved! Go to Solution.
- Labels:
- Data Investigation
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have tried using the TILE tool, but I cannot keep the deciles to be used for further calculations.
In short, I need to evaluate the deciles of multiple columns and then want to assign a value based on the decile of each column. The TILE tool appears to create a non-permanent naming that I can't use to assign a value. Can you help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Did you get a solution for your problem. I am facing a similar issue. I have grouped data based on a category and need to find percentiles (95,96,97,98,99) for a range of values for each of these categories.
Can someone help please ?.
