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.Nicolas Karim supported this idea ·