Keep Filter in Dashboard
I'm trying to figure out how to keep the filters added in a chart when the chart is published in a dashboard. The view in the dashboard doesn't show the filter at all. And even when 'expand' the chart and see the filter, it says 'Filters won't be saved', i.e. even if I change them, the selection won't persist when I click "BACK TO DASHBOARD"
Thank you
Answers
-
Hi David,
This is currently not possible in DSS (but it's on our roadmap). To achieve that, you need to duplicate your dataset, filter it with a Filter recipe and then build the chart on this output dataset.
Hope this helps,
Arnaud -
davidmakovoz Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2022, Neuron 2023 Posts: 67 Neuron
Hi Arnaud,
Thank you for your reply. This is not a viable option. I can't create a copy of my dataset for every single option in the filter.
David
-
Ashley Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
Hi,
With the release of Dataiku 10, we've made dashboard filters available. Here's how:
- Open a dashboard in edit mode
- Add a filter tile using the "+" icon
- Select the source of your filter (i.e. where you want the columns and values to come from)
- Select which columns you want to add as filters
- Save
A dashboard filter tile will apply to all chart and dataset insights on a dashboard slide where shared columns have the same name and type.
To learn more, check out this video that demos this and other improvements made to visualizations in Dataiku 10, take a look at a hands-on tutorial, or browse the reference doc.
Enjoy,
Ashley