Add Custom Dimensions and Measures

Knowledge Checkpoint

A grasp of these concepts will help you understand this documentation better:

• Data Model concept
• Data Model: Dimension and Measure

This is where things start to get interesting. in Holistics, you can create Custom Dimensions and Measures to assist your data exploration.

Custom Dimensions are created from non-aggregate functions that transform existing model fields, and Custom Measures are aggregate functions like SUM, AVG, MIN, MAX... that summarize your data across some dimensions.

Basic aggregations are provided in Holistics's Data Exploration UI, but with Custom Measures you can specify more complicated calculations like conditional SUM.

The video below demonstrates the steps to add Custom Dimensions to your model:

The code we use for the custom dimension is as follows:

case
  when {{budget}} < 1000000 then 'Under $1mil'
  when {{budget}} >= 1000000 and {{budget}} < 5000000 then '$1mil - $5mil'
  when {{budget}} >= 5000000 and {{budget}} < 10000000 then '$5mil - $10mil'
  when {{budget}} >= 10000000 and {{budget}} < 20000000 then '$10mil - $20mil'
  when {{budget}} >= 20000000 and {{budget}} < 50000000 then '$20mil - $50mil'
  when {{budget}} >= 50000000 and {{budget}} < 100000000 then '$50mil - $100mil'
  when {{budget}} >= 100000000 and {{budget}} < 200000000 then '$100mil - $200mil'
  when {{budget}} >= 200000000 and {{budget}} < 300000000 then '$200mil - $300mil'
  when {{budget}} >= 300000000 then 'Over $300mil'
else 'N/A' end