Can we make two colors in a single line chart
Comments
-
The way you would need to do that is to break the lines up in the previous and future values. So based on your example, instead of using 1 measure and a category to split the line into the blue and orange lines. You would instead create 4 beast modes, 2 for your previous (actuals) and 2 for the future values.
Example beastmode:
/* Previous */
CASE WHEN `Date` < CURRENT_DATE() AND `Category` = 1
THEN `Value`
END
/* Future */
CASE WHEN `Date` >= CURRENT_DATE() AND `Category` = 1
THEN `Value`
ENDAs long as you don't add a category at the end of your columns when building the line chart, you can add as many measures as you want.
Hope that helps, let me know if you have any questions,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
This discussion has been closed.
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive