Allow end-users to apply conditional filters to their Klips.
For example: Filter the data to show only Products = ABC, and Price < $1,000
Optionally, allow Klip builders to pre-filter the Klip, or data sources to have filters applied to them before use in a Klip.
We have been approaching this as a concept called ‘dynamic data sources’. This will allow you to create a user input control, say a drop down with geographies, and put a variable in the data source definition related to geographies.
The result would be that as a user changes the input control to, say Canada, the data source is filtered to provide data for Canada.
In the background, an instance of the data source would be created with that value from the drop down populating the variable in the data source query.
If the instance already exists, the dashboard will leverage that like any other data source. If the instance does not already exist, it would be created.
We have been testing this kind of thing for a while and are working on productizing it.
Nicolas Karim commented
Is this feature in yet? I could not find it. I started using this today. I would love to see a way for us to filter data based on top 10 values or 10 most recent values in a table, etc... Otherwise, we cannot use raw data as datasources and have to resort to using other tools to manipulate the data sources before feeding them to the klips.
Hugh Seet commented
Is there an update to this?
Can we pass a variable to a datasource so it is filtered?