Beastmode to manually add annual target - entered value is not appearing on card
I'm trying to use a beastmode to add annual target lines to a bullet chart. Below is my case statement:
When `fiscalyear`='2018' then '1900000'
When `fiscalyear`='2017' then '1500000'
When `fiscalyear`='2016' then '1500000'
We have fiscal year defined in our DOMO configuration and I've selected it on the card.
fiscal year in the case statement is a column in the dataset, however this is not the date being used in the chart (that's using full date, but I'm assuming that these will line up due to using fiscal year on the card).
In the bullet chart I've added this beastmode as the target value.
The problem is that the values being displayed on the card are not matching the values entered in the beastmode. Screenshot attached.
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部