> For the complete documentation index, see [llms.txt](https://docs.myjuicebox.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.myjuicebox.io/building-reports/story-designer/ingredients.md).

# Ingredients

Ingredients are used to configure [charts](/building-reports/story-designer/slices/charts.md) in Juicebox. There are two types of ingredients: [dimensions](#dimensions) and [measures](#measures).

## Dimensions

When you first load your data, you'll have one dimension ingredient for each column in your data. You can create additional dimensions from those data columns. For example, let's say your data has 3 columns: `First_Name`, `Last_Name`, and `Age`. After you load your data, you'll have 3 dimension ingredients corresponding to these 3 columns.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2FmBhmF8GNPAahCl5vgipp%2Fimage.png?alt=media&amp;token=ea49652a-a73d-4f2b-9b73-65c7b04b8e13" alt=""><figcaption><p>Each column in the data becomes a dimension ingredient</p></figcaption></figure>

You can click on the ingredient pill to open the [ingredient editor](/building-reports/story-designer/ingredients/the-ingredient-editor.md). The ingredient editor is where you can see and modify the ingredient definition.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2Fe1tmtRXKhvGaNcDZVsrm%2Fimage.png?alt=media&amp;token=adb2f4df-e2d1-439f-b28b-296eb1da6875" alt=""><figcaption><p>Click on the dimension ingredient pill to open the ingredient editor</p></figcaption></figure>

To create a new dimension, you could duplicate the **First Name** ingredient and modify it to add a new dimension ingredient called **Full Name** that concatenates `First_Name` and `Last_Name` together. After that, you'll have 4 dimension ingredients.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2Fme9LSqNUnV8s6tQD6GPO%2Fimage.png?alt=media&amp;token=31237aba-e90b-4f69-86f5-ef290d6bff4f" alt=""><figcaption><p>A new dimension ingredient called Full Name has been created</p></figcaption></figure>

## Measures

Measures are values calculated over a group of data records. Average sales, student count, and maximum price are all examples of measures. Measures are created using the following aggregation formulas: `sum()`, `avg()`, `min()`, `max()`, and `count_distinct()`. Additional aggregations can be used as well (see [advanced field formulas](/building-reports/story-designer/ingredients/advanced-formulas.md#aggregation-functions)) . Measures are not displayed in the data preview. Instead you see existing measures and add new ones as you configure [charts](/building-reports/story-designer/slices/charts.md).

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2Fzp9khqzKfN14GkvZoqzv%2Fimage.png?alt=media&amp;token=f2b68225-3858-4d79-88ad-6a87daf94b4e" alt=""><figcaption><p>New measures are added as you configure charts</p></figcaption></figure>

As with dimensions, you can click on measure ingredient pills to open the [ingredient editor](/building-reports/story-designer/ingredients/the-ingredient-editor.md).

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2FZE60mHEYjOyUj1koLFOY%2Fimage.png?alt=media&amp;token=0c0bec3b-fd1f-41dd-b02b-f8d7c04f0002" alt=""><figcaption><p>Click on the measure ingredient pill to open the ingredient editor</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.myjuicebox.io/building-reports/story-designer/ingredients.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.