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
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive