Chart

A chart is a data visualization element that can contain a graphical diagram, a table, a map, or an indicator.

You can create a chart with a wizard or with an SQL query based on the data from one or more datasets. You can create an unlimited number of charts from a single dataset.

Wizard

The workspace of the wizard consists of three main parts:

1. A dataset panel where you can see the available Dimensions and Measures fields. You can also add a field and a hierarchy to the list.

   • Dimension contains values that determine data characteristics, for example, a city, a date of purchase, a product category.

     These fields have green icons in the interface.

   • Measure contains values which aggregation functions are applied to, for example, a sum of clicks or a number of views.

     These fields have blue icons in the interface.

   • Visualization also features technical fields named Measure Values and Measure Names. Use them to create grouped column charts, apply colors to chart elements, and show captions for multiple fields at once.

2. A visualization settings panel where you can select a chart type. Each type has its own set of slots where you can add the fields to (for example, X, Y, Colors, Sorting) by drag and drop or by clicking a + button.

3. A preview panel where you can see your visualization change in real time as you modify its settings.

QL

The QL chart interface consists of two main sections:

• Query section. Here you can write the SQL query you want to visualize. You can use the Formula syntax page for reference.

• Chart and dataset preview section. Here you can select the chart type you want to apply to your visualization.

  The table below the chart contains all the data received from the source database with the SQL query.

You can save your charts to workbooks and add them to dashboards.