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.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