<< Click to Display Table of Contents >> Current:  Parameter  Filter data

Parameters can be used to filter data. By assigning parameters, specific data are filtered out.

The following takes the coffee sales information query as an example to introduce to you how to see the desired data through parameter assignment.

1) Add a table component to the dashboard and bind "Product", "Sales" as shown below.

2) Click "Edit Parameters" to open the Edit Parameters window.

3) Click "Add" and name the new parameter "Product" as shown below.

4) Set the optional value. For example, if you select the optional data set, you can select a value from a column of data in the data set when the user assigns a value to the parameter.

5) Click "Select" to select a data set and then select a data column in the data set. The value of this column of data is the value of the parameter that can be selected. For example, the following figure uses the ID value in the "Product" column of the "Coffee" data set as an alternative parameter value.

6) Set how to select the parameter value. You can select a parameter value in the form of a selection box, a check box, a radio box, or a list. For example, select "List" as shown below.

7) Click "OK" to complete the parameter settings.

8) Select the table component and set the filter condition for it. Right-click menu, select "Filter" -> "Filter", open the filter window, as shown below.

9) Click "Add Filter Condition" and set the condition to "Product is =?{Product}", that is, the value of parameter "Product" is the Product we need to see. If we change the value of the parameter "product", the order information we see will also change

10) After "OK", the parameter filter is set.

The following we can look at the effect of parameter filtering.

1) In the review report, open the previous report. In the pop-up parameter window, select a product, for example "Caffe Mocha".

2) After selecting, click "OK". Only "Caffe Mocha" data for "Product" is displayed in the report, as shown below.