image.png

Routines created is the main metric - it is a count of a primary key in a fact table.

Routines (Feed) and Routines (Sleep) are metrics created using the formula of

SELECT {metric/routines_created} WHERE {label/routinetype} = "Sleep"

Each record in the fact table has a type I’m creating metrics that apply a where clause for each type. The sum of Sleep and Feed sub-types cannot be bigger than the overall metric.

What am I doing wrong?