Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Calculating Quartiles from formula in db tool instead of summarize tool

rajatjain
6 - Meteoroid

Hi,

 

I need to calculate percentile but i dont want to use summarize tool since i have to move out from in-db . Is there any way out to use formula tool to calculate quartile ?

danilang
17 - Castor
17 - Castor

Hello @rajatjain 

 

There is a Summarize In-DB tool.  Perhaps this could help you generate your percentiles.  Check out this post from @CharlieS  

 

Dan 

rajatjain
6 - Meteoroid

Hi,

 

The thing is the summarize tool in the IN-DB doesn't have the functionality of percentile like we have in the summarize part of the general tools. The post of charlie is different since there are only values in one column and the values are not being grouped by anything.

 

To achieve this in IN-DB i have to use formula tool somehow which can take a sql expression but i couldn't find anything on that.

 

 

 

Labels