Selecting your data from a list
Filtering data into a smaller dataset is a very important feature to implement when building dashboards. The reason is that people want to have a large amount of data available to them, but they do not want to have to see all of it at once; otherwise, it will become overwhelming for the users. It will require the users to hunt for data, which is not the purpose of a dashboard.
In our example, we will be selecting from a list of regions that will populate a gauge value appropriately:
Getting ready
Have your data list ready. In our example, we will show a simple list of five elements with their corresponding values, as shown in the following screenshot:
How to do it...
- Select a List Box selector from the Selectors section of the Components window and drag it onto the canvas.
- In the general section of the List Box selector, bind the labels to A2:A6, source data to B2:B6, and destination to D2, as shown in the following screenshot. Select Row as the Insertion Type...
