In RubiSight, two types of user-defined values are available 

  • Calculated Column  
  • Parameters 

A Calculated Column is created as a new column created that was not a part of the original dataset. The new column is related to one (or more) of the existing columns in that it is created from them. 

For example, you can add or multiply a fixed number to each value in a column or add two columns to create a new column. Thus, the values in a Calculated Column are not independent of the dataset.  

On the other hand, parameters are static values created for adding to specific columns in a dataset to study their impact on the column values. A parameter is created, and its value is selected independently of the dataset.  Alsoyou can use a parameter inside a Dashboard on any page. 

In RubiSight, four types of Parameters are available –  

  • Categorical 
  • Numerical
  • Interval
  • Boolean 

Each Parameter type requires different set of values for creation. However, they are employed on a Dashboard in the same way. 

In RubiSight, to use the created Parameter, a Calculated Column must be created for the Parameter. 

You can create a Calculated Column by,  

  • Creating an Expression 
  • Using the Code Editor 
  • Using the Parameter