Add a vertical line to a line graph
My data returns the amount expensed per month for the past months. The current month and remaining months for the year show the projected remaining budget. Is it possible to do either of the following?
- Add a vertical line on the current month to show that the line is now showing projected budget, not actual amount expensed.
- Have the line change color once it hits August (the current month).
Thank you!
Comments
-
My first thought is to use series & color rules to plot two lines on the card. Then write a beast mode with a case statement to determine if the date is in the past, or in the future. Suppress the lines so that:
- The past values are "Actual" and are represented by a green line (Jan thru Jul shows that line).
- The future values are "Budget" and are represented by a blue line (Aug thru Dec shows that line).
Am I understanding your question?
0 -
Yes, I believe you are understanding. For the case statement, what would you have as the output? If it's a past month, then ___ ?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive