This recipe will show you how to create a dashboard with the possibility to switch between two charts.
Open a new Dashboard Design file and drag two different chart components (for example, a line chart and a pie chart component) to the empty canvas. Drag the label-based menu component to the canvas, as well.
Click on the line chart component and go to the Behavior tab of its properties pane. At the bottom of the pane, you will see a section called Dynamic Visibility.
Bind the Status field to spreadsheet cell B1.
Put the value 1 in the Key field.
Click on the pie chart component and go to the Behavior tab.
Here you also bind the Status field to cell B1.
In the Key field, you fill in the value 2.
Go to the spreadsheet and type Status: in cell A1 and put value 1 in cell B1.
Now click on the label-based menu component and go to the General tab of its properties pane.
To set the labels, click on the button on the extreme right-hand side.
Ente...