Introduction
Chart filters are filters applied to a specific object or visualization.
There are several types of chart filters:
Chart Filters- an additional filter to the global filters, defined on specific fields; the values to filter on can be set manually or by a variable.
Result Filters - Filters applied to the results of measures in the chart; the values to filter on can be set manually or by a variable.
Global Filter Settings- Define the impact of global filters on the chart.
(Show the effect of global filters on a chart)Time travel- Set the time travel value for the data source.
Global Filter Settings (Show the effect of global filters)
Chart Filters
Chart filters add filters to the global filters that are specific to the chart.
Chart filters can be applied to all fields connected to the chart's dimension.
There can be multiple chart filters. The Astrato engine will use the AND operator to combine the different filters.
Technical definition: The chart filters are applied as part of the Where clause in the SQL query.
In the example below, the chart filters will display customers with a yearly income between $50,000 and $100,000 and only female customers.
Result Filters
Result filters are applied to measure results, after the measure is calculated for the combination of dimensions.
Technical Definition: The results filters are applied as part of Having clause in the SQL Query
The example below will display only records where the number of orders exceeds 2,000.
Global Filter Settings
Global filter settings allow you to override the default global filters behavior, which applies all the global filters to the chart query.
There are several settings:
Ignore global filters- this is the main switch.
When enabled, global filters aren't added to the chart query.
Show the effect of global filters: when global filters are ignored, applying a filter to the chart's dimension highlights the selected values in the chart.
* Highlighting the values works only when filters from the table connected directly to the chart dimension are applied.In the example below, selection on the product subcategory field is ignored.
And the impact of selection in the sub-category field will be displayed in the chart.
When making a selection in the product subcategory field, the filtered values are highlighted in blue. The chart still displays all subcategories, even though a filter has been applied to the field.
Time Travel
Time travel enables querying a version of the data at the specified timestamp.
* This feature is currently available only in Snowflake and Databricks connections.
If you would like to learn more about Time travel, you can check this article.