♟️Working with sample datasets

Learn how to process queries on a sample dataset instead of the full dataset

Usually, once a user chooses a chart to add to a Vizpad, the results are rendered to the entire dataset. To avoid the time-consuming overhead while processing large datasets, Tellius introduces an option using which you can query for only sample data. This results in faster iterations and makes the overall process more efficient and time-saving. The super admins can determine whether users can enable/disable sample data to run the queries.

When enabled, queries will be applied to the first 5000 rows of a dataset. Querying on sample data is recommended while dealing with Live connections and/or large datasets.

The sample data is applicable only while building the Vizpad. Once the Vizpad is saved, the results will be reflected in the entire dataset.

Sample data vs Full data in Vizpads

When you are editing/building a Vizpad from Explore, you can find the Run queries on dropdown.

• Select Sample data to query sample data.

• Select Full data to query the entire dataset.

Configuring the "Sample Dataset" toggle

The toggle button in the Vizpad will be hidden by default. The visibility of the toggle button can be set up in Settings.

To enable users to choose the required data size,

1. Navigate to Settings → Application Settings → Vizpad.

2. Under Editing the Vizpad, switch on the toggle for Data limitation for queries.

3. When it’s switched on, users can choose if they want the results to be applied on a limited (Sample Data) or entire dataset (Full Data).

4. By default, querying on Sample data will be enabled during edit mode.

Configuring the sample dataset