When you first add data to your query, auto-mode will automatically select a chart type. This support tip will discuss how your data will affect the type of chart auto-mode selects. For more information on the different types of visualizations see, Visualization types reference.
Auto-charts for metrics
The first condition auto-mode checks is whether or not your query contains attributes. If your query does not include attributes, auto-mode will select a chart type based on the number of metrics added.
Below are the conditions auto-mode checks before selecting a chart:
-
If your query contains only one metric, your results will be displayed as a KPI chart (see
KPI chart
).
-
If your query contains two metrics, your results will be displayed as a table (see
Customizing grids
).
-
If your query contains three or more metrics, your results will be displayed as a radar chart (see
Radar chart
).
Auto-charts for attributes
If your query contains attributes, auto-mode checks additional conditions before selecting a chart type. Auto-mode first categorizes what kind of attribute is added, then checks the conditions for that attribute type.
Date attribute conditions
-
If your query contains only one metric, date attributes on Columns with only one value selected, and a category attribute on Rows, your results will be displayed as a column chart (see
Column charts
).
- If your query contains only one metric and date attributes on Columns, your results will be displayed as an area chart (see Area charts ).
-
If your query contains more than one metric and more than one date attribute, your results will be displayed as a line chart (see
Line charts
).
Category attributes
-
If your query produces only one cell of data, your results will be displayed in a KPI chart underneath the headline number.
-
If your query contains only location attributes, your results will be displayed as a map (see Viewing results by location ).
-
If your query contains only one metric and attributes that all have five or less values, your results will be displayed as a pie chart (see Pie charts ).
-
If your query contains an attribute and two metrics, your results will be displayed as a bubble chart (see
Using metrics as axes with bubble chart
).
-
If your query contains only one metric and all attributes have more than five values with labels of less than 15 characters, your results will be displayed as a column chart.

- If your query contains only one metric and all attribute labels have more than five values with labels of more than 15 characters, your results will be displayed in a bar chart (see Bar charts ).

- If your query does not match any of the conditions from above, your results will be displayed as a table.
0 Comments