This recipe will show you how to create a dashboard with the option of switching between two charts.
Open a new SAP BusinessObjects Dashboards file and drag two different chart components (for example, a Line Chart and a Pie Chart component) into the empty canvas. Drag the Label Based Menu component found in Selectors into 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.
Put value
1in the Key field:
Click on the Pie Chart component and go to the Behavior tab.
Here also, bind the Status field to cell B1.
In the Key field, fill in the value
2:
Go to the spreadsheet and type
Status:in cell A1 and put value1in 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...