PERCENTILE_AGG- FineBI Document

Last update： 2022-04-06

1. Overview

Grammar	PERCENTILE_AGG(array,percentile)	According to the current analysis dimension, the value at the percentile corresponding to the specified number is returned from the given expression. The number must be between 0 and 1 (inclusive), such as 0.66, and must be a numeric constant.
Parameter	array	It must be the result returned by a non-aggregate function formula, which can be a calculation result of an indicator field, dimension, or indicator field and a common formula. The insertion of text and date is not supported.

2. Matters needing attention

Use when extracting data is not supported.
Supports the use of two numeric type parameters, and the second parameter must be a constant.

3. Examples

When the user's horizontal axis is the dimension field "Day", the calculated indicator PERCENTILE_AGG (Sales, 0.95) of the vertical axis returns a value of 95% of the daily sales;

When the user's horizontal axis is the dimension field "Month", the value returned by PERCENTILE_AGG(Sales, 0.95) is 95% of the monthly sales.

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

PERCENTILE_AGG

1. Overview

2. Matters needing attention

3. Examples

附件列表