Drop down to show/hide visuals

#1

Hi everyone,


I'm fairly new to The Cube and to Dundas BI so please bare with me. If I put this topic in the wrong section please let me know too.


I have created multiple layers and placed a visual on each. I wanted to control (show/hide) each layer based on a drop down selection, but I also wanted to re-animate the layer/visual every time the visual is shown again (based on the drop down selection). Is there anyway to achieve this through the native functionality of the tool? Or would this be done through scripting?


Thanks in advance!

#2

Welcome to The Cube!


Generally, you would look at using the Change Layer interaction for this situation. However, the complication in your case is the drop down selection. Since the option in the drop down will be custom, you would have to somehow indicate which option selection does what, which can only be done via script.


As for the re-animation part, you can add filter interactions that set the filtering to None when the visualization is hidden and re-introduces the required filtering when it is visible. The change in view parameter will animate the visualization.

#3

Hi Elia,


Thanks for the reply!


I'm fairly new to Dundas BI, for the re-animation comment you made how would I go about implementing the steps you mentioned above? Is this done via scripting too?


Thanks!

#4

That part can be done without scripting. you can find an example in the article Use a button to apply a filter value.


And let me know if you need any help with the layer change scripting.

#5

I have to correct myself. Seems I forgot a functionality that was introduced in Version 3 and you do have the ability to use the Change Layer interaction with the drop down list, without scripting. You simply choose which item to use the interaction for:

Image title