> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# quantilesTimingIf

> quantilesTimingIf 组合器使用示例

<div id="description">
  ## 描述
</div>

[`If`](/zh/reference/functions/aggregate-functions/combinators#-if) 组合器可应用于 [`quantilesTiming`](/zh/reference/functions/aggregate-functions/quantileTiming)
函数，使用 `quantilesTimingIf` 聚合组合器函数
计算条件为 true 的行中时序值的分位数。

<div id="example-usage">
  ## 示例用法
</div>

在本示例中，我们将创建一个表，用于存储不同端点的 API 响应时间，
并使用 `quantilesTimingIf` 计算成功请求的响应时间分位数。

```sql title="Query" theme={null}
CREATE TABLE api_responses(
    endpoint String,
    response_time_ms UInt32,
    is_successful UInt8
) ENGINE = MergeTree
ORDER BY ();

INSERT INTO api_responses VALUES
    ('orders', 82, 1),
    ('orders', 94, 1),
    ('orders', 98, 1),
    ('orders', 87, 1),
    ('orders', 103, 1),
    ('orders', 92, 1),
    ('orders', 89, 1),
    ('orders', 105, 1),
    ('products', 45, 1),
    ('products', 52, 1),
    ('products', 48, 1),
    ('products', 51, 1),
    ('products', 49, 1),
    ('products', 53, 1),
    ('products', 47, 1),
    ('products', 50, 1),
    ('users', 120, 0),
    ('users', 125, 0),
    ('users', 118, 0),
    ('users', 122, 0),
    ('users', 121, 0),
    ('users', 119, 0),
    ('users', 123, 0),
    ('users', 124, 0);

SELECT
    endpoint,
    quantilesTimingIf(0, 0.25, 0.5, 0.75, 0.95, 0.99, 1.0)(response_time_ms, is_successful = 1) as response_time_quantiles
FROM api_responses
GROUP BY endpoint;
```

The `quantilesTimingIf` 函数仅对成功请求 (is\_successful = 1) 计算分位数。
返回的数组按顺序包含以下分位数：

* 0 (最小值)
* 0.25 (第一四分位数)
* 0.5 (中位数)
* 0.75 (第三四分位数)
* 0.95 (第 95 百分位数)
* 0.99 (第 99 百分位数)
* 1.0 (最大值)

```response title="Response" theme={null}
   ┌─endpoint─┬─response_time_quantiles─────────────────────────────────────────────┐
1. │ orders   │ [82, 87, 92, 98, 103, 104, 105]                                     │
2. │ products │ [45, 47, 49, 51, 52, 52, 53]                                        │
3. │ users    │ [nan, nan, nan, nan, nan, nan, nan]                                 │
   └──────────┴─────────────────────────────────────────────────────────────────────┘
```

<div id="see-also">
  ## 另请参阅
</div>

* [`quantilesTiming`](/zh/reference/functions/aggregate-functions/quantileTiming)
* [`If 组合器`](/zh/reference/functions/aggregate-functions/combinators#-if)