Beastmode to manually add annual target - entered value is not appearing on card
Hi,
I'm trying to use a beastmode to add annual target lines to a bullet chart. Below is my case statement:
Case
When `fiscalyear`='2018' then '1900000'
When `fiscalyear`='2017' then '1500000'
When `fiscalyear`='2016' then '1500000'
End
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.
Best Answer
-
I was able to fix this on my own.
Just needed to select no aggregation on the target value.
0
Answers
-
I was able to fix this on my own.
Just needed to select no aggregation on the target value.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive