Beast Mode Scale Markers?
I have a chart showing a performance metric across various ads. What I'd like to do is add a threshold scale marker, so that when things fall below we can take action.
However, the scale marker calculation is different from my beast mode.
IFNULL(SUM(CASE WHEN `Objective` LIKE '%BRAND%' THEN (`EARL`) ELSE 0 END) / SUM(CASE WHEN `Objective` LIKE '%BRAND%' THEN (`Reach`) ELSE 0 END),0)
I assume this is based on the granualirty of the data, the scale marker using individual points and the beast mode using total sums, but the difference can be a lot and also is affecting thresholds.
I've played around with different chart types, hoping use a combo line + bar chart with my line as a beast mode, but the dimension I'm using only shows up at the count level, which is not what I want. Nor do I want my beast mode to vary week by week - I want a static line based on the entire date range.
Does anyone know a way to use a beast mode as a scale marker?