Adding Calculated Column to Dashboard

Adding Calculated Column to Dashboard

To add a calculated column to your dashboard, follow the steps given below.

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




    The Add Calculated Column page is displayed.


    The table given below describes the different fields present on the Add Calculated Column page.


Field

Description

Remark

Calculated Column Name

It allows you to enter the name of the newly created calculated column.

—

Variable Type

It allows you to select the variable type of the feature. If it is not selected, the system defines the variable type on the click of Validate.

The available options are,

  • Categorical
  • Numerical
  • Interval

Data type

It displays the data type of the feature based on the selected variable type. The system defines it as per the output type of the expression.

—

Hyperlink to access the online help for Expression.

—

It deletes the built expressions and closes the Add column Page. It removes the unsaved changes.

—

           

It validates the expression based on the selected features, operators, and the variable type of the newly created column. It also returns the data type of output of the given expression.

—

    

It adds the newly created column to the dataset features.

—

On the Add Calculated Column page, 

  1. Enter the Calculated column name.
  2. Select the Variable Type from the drop-down. This step is optional. If you do not select the variable type, the system defines it on the click of Validate.
  3. Build your expression for a new column to be added. Refer Expression.
  4. Once the expression is ready, validate the expression. Click Validate.
    If the expression is valid, Expression is valid message is displayed.
  5. To add the new calculated column, click Add.



    The newly calculated column is added to the dashboard and is displayed in the list with a © symbol. It can be used to plot widgets.