Hello,
I am using an input variable as a drop down menu with a list of datasets. I would like to select a specific dataset using the drop down menu and the values in that dataset should be used to make calculations for the rest of the dashboard. The specific selection is made using a filter pane but I would not like to use that.
I have attached images for further explanation.
If anyone has possible solutions for why the selection is not being made and updating the dashboard, please let me know. Thanks!
In the imagine above there is a drop down menu and a filter pane.
After making a selection using the drop down menu the number of units and work orders do not change.
This is the code used for the variable input dynamic value.
= 'Select Dataset |' & concat(distinct dataset, '|')
Only using a filter pane selection, the values change. But I need them to change after making a selection using the drop down menu.