How chart types are selected in auto-mode

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.

This tip contains the following sections:

• Auto-charts for metrics
• Auto-charts for attributes

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.

Below are the different attribute types:

• Date attributes
• Category attributes

Date attribute conditions

If your query contains date attributes, including timestamps, auto-mode will use the following conditions to select a chart type.

• 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

Any attributes that do not contain dates or timestamps, such as IDs, names, and locations, are referred to as category attributes. Auto-mode will use the following conditions to select a chart type for 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.