Dataset data model

Visualization dataset connects to a data source, organizes its data into data fields, applies data aggregation functions to them.

Data source

A link is created automatically when field names and/or field data types from two different sources match. You can also specify the fields of the tables to be connected.

Tables support the following operations:

  • Change fields in a link.
  • Add a new link or remove an existing one.
  • Change the JOIN operator type in a link (inner, left, right, full).

Data fields

Table columns are processed into dataset fields. They determine the structure of a dataset.

The fields with aggregation functions applied to them are colored blue in the interface. They become Measures.

The fields without any aggregation functions applied to them are colored green in the interface. They become Dimensions.

To read more on measures and dimensions, see the Charts Overview.

Visualization allows you to create calculated fields with formulas. Use the corresponding dataset fields to enter formulas, constants, and functions.

Data aggregation

Visualization supports the following data aggregation functions for various data types:

Function Description Supported data types
None No aggregation All types
Average Arithmetical mean float, integer
Count Number of entries string, date, datetime, float, integer
Maximum Maximum value date, datetime, float, integer
Minimum Minimum value date, datetime, float, integer
Number of unique Number of unique entries string, date, datetime, float, integer
Sum Sum of values float, integer