Creating Range
Last updated
Last updated
Check out the given walk through on how to create a Range using the Create Formula window.
The user can create a new calculated field in the selected data store using the Range tab.
Navigate to the Design Workspace.
Select the required fields to the top bar.
Click the GO option.
The View gets created based in the selected fields. E.g., the following image displays Employee names with sum of Experience.
Click the Formula Field Editor icon.
The Create Calculated Field window opens.
Select the Range tab.
Name: Provide a title for the formula field.
Measure: Select a Measure field using the drop-down menu.
Click the ADD ROW option.
Provide the following information to create a range:
Name: Provide a name for the defined range.
From: Set a minimum value to define a specific range.
To: Set a maximum value to define a specific range.
(the following image displays multiple ranges added based on the values from the experience field).
Click the Save option.
A new calculated field gets added to the selected Data Store.
Select the newly created calculated field and add it to the top menu bar.
Click the GO option.
The calculated field will display the range based on the experience value.
