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

# into_values()

> Get a table of all frequency estimates from a space-saving aggregate

<Icon icon="tag" iconType="duotone" /> Since [1.16.0][toolkit-1.16.0]

Return the data from a space-saving aggregate as a table. The table lists the stored values with the minimum and maximum
bounds for their estimated frequencies.

## Arguments

The syntax is:

```sql theme={"dark"}
into_values(
    agg SpaceSavingAggregate
) RETURNS (AnyElement, DOUBLE PRECISION, DOUBLE PRECISION)
```

| Name  | Type                 | Default | Required | Description                                                                                  |
| ----- | -------------------- | ------- | -------- | -------------------------------------------------------------------------------------------- |
| `agg` | SpaceSavingAggregate | -       | ✔        | A space-saving aggregate created using either [`freq_agg`][freq-agg] or [`mcv_agg`][mcv-agg] |

## Returns

| Column    | Type             | Description                                   |
| --------- | ---------------- | --------------------------------------------- |
| value     | AnyElement       | A commonly seen value in the original dataset |
| min\_freq | DOUBLE PRECISION | The minimum bound for the estimated frequency |
| max\_freq | DOUBLE PRECISION | The maximum bound for the estimated frequency |

[freq-agg]: /api-reference/timescaledb-toolkit/frequency-analysis/freq_agg/freq_agg

[mcv-agg]: /api-reference/timescaledb-toolkit/frequency-analysis/freq_agg/mcv_agg

[toolkit-1.16.0]: https://github.com/timescale/timescaledb-toolkit/releases/tag/1.16.0
