Skip to main content

Varicent ELT Help Center

Percentile

Abstract

Computes the specified quantile value between 0 and 1.

Use the Percentile tool to understand the frequency of data by grouping values. The Percentile tool computes the specified quantile value between 0 and 1.

Although this tool is called percentile, it actually uses quantile values. A quantile shows where a value falls based on the range of values. For example, 0.25 quantile = 25 percentile and .5 quantile = 50 percentile. Most of the time, you can think of quantiles as percentiles, and you'll still be able to understand your data.

Tip

Quantile isn't the same as quartile! Quartiles divide values into four equal parts. For example, quartile 1 = 0.25 quantile = 25 percentile. A quartile is a type of quantile.

Input

The Percentile tool requires one data input.

Configuration

Use the following configuration options to configure the Percentile tool.

Configuring the Percentile tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.

  5. In the Tools modal, search for Percentile and then click + Add Tool.

    Tip

    You can also find the Percentile tool in the Organize section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, enter the following information:

    Table 86. Percentile tool configuration

    Field

    Description

    Group by columns

    Select the columns that you want to group.

    Percentile column

    Select the column to use as the percentile column.

    Percentile

    Enter the percentile to use, or use the arrows to increase or decrease the amount.

    For example, if you want to know the length of time of 95% customer service calls, you can input 0.95. This would show the length of time of 95% of the calls.

    New column name

    Enter the new column name for the percentile.

    + Add percentile

    Click to add another percentile to your data set.

    + Add percentile column

    Click to add another percentile column to your data set.



Usage example

Let's say you want to analyze the performance of your sellers based on their monthly sales figures. By using the Percentile tool, you can categorize sellers into different performance groups. For example, if a seller's sales volume is in the 0.25 quantile, this indicates that the seller's sales are higher than 25% of other sellers—putting them in the 25th percentile. Similarly, being in the 0.75 quantile means the seller outperforms 75% of their peers, placing them in the 75th percentile. By applying these quantile calculations, the platform can easily identify top performers and those needing improvement, allowing for targeted strategies to enhance overall sales performance.