反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

PERCENTILE_AGG

  • Recent Updates: April 06, 2022

    • 1. Overview

    GrammarPERCENTILE_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.
    Parameterarray

    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.

    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭