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
JOINoperator 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 |