Ingredients
Last updated
Was this helpful?
Last updated
Was this helpful?
Ingredients are used to configure in Juicebox. There are two types of ingredients: and .
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.
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.
You can click on the ingredient pill to open the . The ingredient editor is where you can see and modify the ingredient definition.
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 ) . Measures are not displayed in the data preview. Instead you see existing measures and add new ones as you configure .
As with dimensions, you can click on measure ingredient pills to open the .
