Dynamic goal line
Best Answer
-
When you add a goal as a beast mode you can use it as a series just like any other data. You wouldn't have to add it as a goal line, but as an additional value series to the chart.
In this case, it wouldn't work on the 100% stacked bar chart you have, but other visualizations may be possible.
0
Answers
-
I tried this and it looks like it works.
(DATEDIFF(CURDATE(),'12/31/2016') / DATEDIFF('12/31/2016','10/1/2016'))*-1
It's not complete, but you can definitely use a CASE WHEN argument to move this value dynamically.
Try it without the CASE WHEN first, then you can add clauses later. Not 100% sure how to avoid hard coding dates
CASE
WHEN QUARTER(CURDATE() = 4) THEN (DATEDIFF(CURDATE(),'12/31/2016') / DATEDIFF('12/31/2016','10/1/2016'))*-1
WHEN QUARTER(CURDATE() = 3) THEN (DATEDIFF(CURDATE(),'9/30/2016') / DATEDIFF('9/30/2016','7/1/2016'))*-1
Etc.
Hope this helps.
0 -
@Hua, did @keithhickman07's reply help you out?
0 -
I will give it a try. In theory the calculation part is easy through beastmode. I will need to see how it can be displayed on the chart. "Goal" line in bar charts seem to only take constant. If you have any suggestion on what chart type should be used, that'll be great!
Thanks,
Hua0 -
When you add a goal as a beast mode you can use it as a series just like any other data. You wouldn't have to add it as a goal line, but as an additional value series to the chart.
In this case, it wouldn't work on the 100% stacked bar chart you have, but other visualizations may be possible.
0 -
@Hua, tagging you to check out @Kung-fu_Panda's reply.
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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive