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?
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 501 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board