Dataset settings

Dataset settings determine the way you can connect one or more tables and apply default filters to new charts.

Connect one or more tables

If a source contains more than one table, you can connect them using a JOIN operator. To do this, create a connection and define the fields of the source table, and the fields of the table you connect to.

You can apply the following JOIN operators to your connection:

A dataset operates in the direct access mode, with all data requests processed on the side of the source.

Default filters for new charts

Datasets allow you to create default filters for new charts. They will be applied to all new charts created from this dataset.

Use default filters to:

  • Limit the amount of data queried from the source when creating a chart
  • Avoid filter duplication for new charts from the same dataset.

Note

  • You can create a filter from a separate chart in chart settings. This separate filter will override the existing default filter(s).
  • Default filters are not applied to the data in the preview section.