This can be achieved now using the API (currently in beta). We are looking into exposing it in the UI in a future release.Info Xcentric commented
love this idea. We have tons of datasources.. also due to enthusiastic use.. and it's difficult to know which datasources can be safely deleted.
12 votesInfo Xcentric shared this idea ·
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.