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

# Creating a Range

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

![Creating various Range within the given Data](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fsd7eGa28M2EEGNqhSRMW%2FRange.gif?alt=media\&token=0906a6cb-adea-4cac-89d9-59dc126065f6)

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.   

![Accessing the Formula Field icon ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FvA4nOfYZ44OA1yw19NEX%2Fimage.png?alt=media\&token=a09b4da3-51a8-4e5f-83c0-29dcb9da3872)

* The ***Create Formula*** 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 for the created 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.
* Click the ***SAVE*** option. 

![Creating a new Range](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FjuiNeCkddqfFdV4TiZdP%2Fimage.png?alt=media\&token=cd24130e-f55d-4bca-b2c1-8b377ec82ad7)

* The selected Data Store gets a new calculated field. 

       ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FpfUHTtdYmssba0MGw0fA%2Fimage.png?alt=media\&token=758a376e-c3f6-4270-b862-ccbcf69d02e6)

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>* ***Range*** 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***.&#x20;
{% endhint %}