Hi everyone, I hope you're all doing well!
I'm currently working on an AI/BI dashboard designed for business users, where the goal is for users to simply view and interact with the data in the dashboard. I've asked this question before to the Agent and although I was told that this kind of classic BI functionality is not supported on the platform, I'm wondering if there might be a workaround.
In my dataset, I have around 200 variables ( dimensions ) and each variable can have between 2 and 10 possible values. Is there a way to dynamically create global parameters such that:
- The first parameter allows the user to select one ( or more ) variables from this set of 200 and
- Based on that selection, a second global parameter automatically updates to show only the values associated with the selected variable(s)?
For example:
If the user selects the car ownership variable, the second parameter should only display the values yes and no
If the user then selects car color, the second parameter should update to show only red, black, grey
Is this type of dynamic, dependent parameter set up possible or is there any known workaround to achieve this behavior?
Creating 200 x 2 individual parameters - one for each variable and it's corresponding values - is not a viable solution as it would result in a very poor and cluttered user experience. I figured out that is doable to create a global parameter that contains all variables. However, the associated global "value" parameter would then include all possible values from the dataset, allowing users to search for the value they want. I don't believe this is the best approach as many variables share the same values and this could easily lead users to select an incorrect value.
I also want to avoid using another BI tool to build this dashboard. My goal is to find a solution using only the features available within Databricks
