Appearance
Filter, sort, and limit
A chart's basic settings let you control the filtering, order, and row count of the data to render. Some charts let you set the order of series separately from the order of the data.
Source filter
Source filter lets you narrow down the data source and limit the data to render. This condition is applied before aggregation.
A condition combines a column, an operator, and a value. The operators are shown on screen as follows.
| Operator | Typical use |
|---|---|
= / != | Equal / not equal. |
> / >= / < / <= | Comparison. |
IS NULL / IS NOT NULL | NULL check. |
IN / NOT IN | Matches one of multiple values. |
BETWEEN | Range. |
LIKE | Pattern match. |
You can also write a condition expression directly with Custom SQL. Conditions can be combined with AND / OR.
Sort
Depending on the chart type, you can set Sort, X-axis sort, Row sort / Column sort, and so on.
The sort types are as follows.
| Type | Description |
|---|---|
| Value | Sorts by the metric's value. Order is ascending / descending. |
| Label | Sorts by the dimension's value. Order is ascending / descending. |
| Custom | Sorts by a specified column or aggregation. |
For XY Chart's Value sort, the condition specified for the first Y value in Series is used.
For some chart types, the meaning of the sort affects the rendering. For example, in Funnel Chart, the sort type changes the basis for the ratio calculation. See each chart type's page for details.
Group sort
For charts that have Group by, Group sort lets you specify the order of series and the legend.
| Type | Description |
|---|---|
| Label | Ascending or descending order of the value specified in group by. |
| Custom | Ascending or descending order of a specified column. Specify a column that's uniquely determined for the grouped value (for example: group by user name → sort by user ID). |
Limit rows
Limit rows restricts the number of rows of data to render, from 1 to 1000.
The data to render is capped at 1000 rows. If the limit is exceeded, the message "Rendered with up to 1000 rows of data" is shown. Combining a row limit with sort lets you visualize the top N items.
Group by vs. frame
Even when using the same dimension, group by and frame produce different appearances.
| Item | Group by | Frame |
|---|---|---|
| On-screen label | Group by | Frame |
| Appearance | Splits the series within the same chart (for example, by color). | Splits the chart itself by the column's value. |
| Typical use | Comparing within a single figure. | Comparing small charts side by side. |
See Frame for the frame layout (Timeline / Grid).