> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-5/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-5/design-canvas/create-calculated-field/creating-range.md).

# Creating Range

This section provides steps to create a range using the calculated field option.

{% hint style="success" %}
*Check out the walk-through on creating a Range using the Create Formula window.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FiTvMxtE7vYVd1WUfaAxy%2FCreating%20Ranges%20as%20a%20Calculated%20Field.mp4?alt=media&token=4c167dbc-3c5f-46bb-b72d-0e05d6bd1006>" %}
***Creating various Ranges***&#x20;
{% endembed %}

The user can create a new calculated field in the selected data store using the ***Range*** tab.

* Navigate to the ***Design*** Workspace.
* Click the ***Formula Field Editor*** icon.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FALMDU1RyJ52mEaWSwIYb%2Fimage.png?alt=media&amp;token=eddb7a9b-a927-404f-a61c-e1cec46e0378" alt=""><figcaption></figcaption></figure>

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

* The ***Create Calculated Field*** window opens.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2Fd2BjRlsW2kchM8aBsAcq%2Fimage.png?alt=media&amp;token=1f9e16e9-8ac2-4703-a8d3-b45d54c0bad2" alt=""><figcaption></figcaption></figure>

* 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 range.
  * Click the ***Add*** icon.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FLuBU9F81qxabcZqzGzcO%2Fimage.png?alt=media&amp;token=fbd96094-d71f-4b45-9fbb-e7d60cff24b2" alt=""><figcaption></figcaption></figure>

* A new field gets added to create a new Range.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FdNAv0Wvm365TUN1fTbmv%2Fimage.png?alt=media&amp;token=ea7514e9-ff09-4402-b3dc-92dc3437a2ea" alt=""><figcaption></figcaption></figure>

* You may insert multiple ranges and define them.
* Click the ***Save*** option.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2F639pDp99OxYmJI6NylR9%2Fimage.png?alt=media&amp;token=3c106de3-e42e-40e7-b52d-334aca522ddd" alt=""><figcaption><p><em><strong>Multiple Ranges created for Experience</strong></em></p></figcaption></figure>

* A new calculated field gets added to the selected Data Store.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FqelgY7Osx0wdycF8618D%2Fimage.png?alt=media&amp;token=123ea6dd-495e-4b5e-88d9-109675b8442d" alt=""><figcaption></figcaption></figure>

* 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://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FUQWze379lnubBzR5zPPW%2Fimage.png?alt=media&amp;token=7152c9d8-0647-4e52-b0d4-be11c9b2a2b2" 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 the 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 ranges gets added a Dimension by default.*
  {% endhint %}