How specific can I get with dynamic scale markers?
I'm working on a year-over-year card where I want to add a goal line that represents a 10% reduction from the previous year. However, this is a card that I have a slicer for, so I want that line to be dynamic as the data changes. Is that possible? The furthest I was able to get was to create a percentage scale marker that was tracked off of the maximum data. Unfortunately, that doesn't meet all usecases.
I'm not able to upload images due to firewall conflicts, so I'll do my best to explain:
I have a chart where the X axis is years (2020-2022), and the Y axis is cost. Each year has a bar for major and minor costs (so 6 bars total, divided into 3 year buckets). I want to have a goal line that is set at 90% of the 2021 major cost bar, and ideally a second goal line set at 90% of the 2021 minor cost bar. When I filter this card, I want those lines to update accordingly?
Is this possible?
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board