Define Numerical Variables

Numerical variables assign specified values to different users. They can then affect how associated metrics are calculated within a user’s reports.

This could be useful when different users in a company receive different commission rates.

For example, the Commission Amount metric in each user’s report depends on the value of numerical_variable that has been assigned to them:

SELECT SUM (Sale Amount) * {numerical_variable}

Steps:

  1. In the top navigation bar, click Manage
  2. Click the Data tab, then click Variables.
  3. In the Variables page, click Create Variable.
  4. Enter a name for the variable. Click Ok.
  5. For the variable type, select the Numerical Variable checkbox. 
  6. Assign the default value for all users.
  7. (Optional) For each user in the workspace, click the Set link in the Value column to assign a user specific value. Click the Default link to reset the user to the default variable value.  
      
  8. When done with configuring the variable, click Save Changes.