> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-4/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/self-service-visualization-4/design-canvas/create-calculated-field/creating-range.md).

# Creating Range

{% hint style="success" %}
*Check out the given walk through on how to create a Range using the Create Formula window.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FPJkBo0vMfUbTbWH9iwQn%2FRange%20in%20Calculated%20field.mp4?alt=media&token=76c0724c-986c-4840-b2ed-a3ffc79748d0>" %}
***Creating various Range***&#x20;
{% endembed %}

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.&#x20;
* Click the ***Formula Field Editor*** icon.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/4dUZ3WiJM9uCSXZMTHn3/image.png" alt=""><figcaption></figcaption></figure>

* 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.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/ECJsTLYJlHl5hOV958Y7/image.png" alt=""><figcaption></figcaption></figure>

* 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.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/DaGxdG2Lda8xbZSehRFb/image.png" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*&#x20;

* *The **Range** option will not be listed for the space where MongoDB server is configured in the **Admin Settings**. The Range functionality is available only if the Elastic Search configuration is done from the **Admin Settings**.*
* *The Calculated Field with various range gets added a Dimension by default.*
  {% endhint %}