The created Parameter can be used in the Dashboard on any page. To use the Parameter, we first create a Calculated Column based on the Parameter.

To create a Calculated Column, follow the steps given below.

1. Open the Dashboard in edit mode. Refer to Editing the dashboard.
   The Dashboard is displayed.
2. Add a dataset to the Dashboard. Refer to Adding a dataset to the dashboard.
3. In the DATA pane, click the ellipsis corresponding to the dataset, and then click Add calculated column from the listed options.
   
   
   
   

   The Add Calculated Column page is displayed.

4. Enter the Calculated column name.
5. Select the Variable Type from the drop-down.
   
   
   

Creating Calculated Column by Creating an Expression

To create an Expression, follow the steps given below.

1. Perform steps 1 to 5 of Adding Calculated Column to Dataset.
   In this example, the Calculated column name is Num-Quantity and the Variable Type selected is numerical.
2. In the left pane, click the Expression that you want to apply. In the example, we use the Mathematical
   Corresponding operators are displayed.
   
3. Select the required operator. For more information about operators in Rubiscape, refer to Operators in Expression Builder.
   In the example, the Addition operator is selected.
   
   The selected operator is added to the canvas.
4. Click Features in the left pane.
   The feature block is added to the canvas.
   In the example, we select the Quantity variable as the feature.

5. Click the feature block and select the required feature from the drop-down.
   
   
   

6. Click Parameter in the left pane.
   The created Parameter is displayed on the canvas. In the example, the Numerical Parameter created is displayed on the canvas.
   
   
   
   

7. Based on your requirement, add the Feature and Parameter to the operator and create your expression
   
   

8. Click Validate.
   If the expression is valid, a confirmation message is displayed in the bottom-left corner.

9. Click Add.
   
   

   The selected Parameter is added as a column to the dataset.

10. In the DATA pane, click the Measures drop-down.
    
    
    
    

    The newly added Calculated Column is displayed in the list with a © symbol.

    The selected Parameter can be used with the newly created Calculated Column. In the example, the Numerical Parameter Num­_Parameter can be used with the newly created Calculated Column, Num_Column.

Creating Calculated Column using Parameter 

You can create a Calculated Column using a newly created Parameter directly, then validate it, and use it in the Dashboard.

To create a Calculated Column using a newly created Parameter, follow the steps given below.

1. Perform steps 1 to 5 of Adding Calculated Column to Dataset.
   In this example, the Calculated column name is Cat-Column and the Variable Type selected is categorical.
2. In the left pane, click Parameter.
   The created Parameters block is added to the canvas.
3. Click the Parameter block and select the required Parameter from the drop-down.
   In the example, we select the Cat_UIParameter, which is a categorical parameter.
4. Click Validate.
   If the Parameter is valid, a confirmation message is displayed in the bottom-left corner.
5. Click Add.
   
   
   The selected Parameter is added as a column to the dataset.

6. In the DATA pane, click the Dimensions drop-down.
   
   
   The newly added Calculated Column is displayed in the list with a © symbol. The dataset can be used with the newly added Calculated Column.
   
   

   Note:

   You can abort the addition of the Calculated Column and close the page by using Cancel.