Can we make two colors in a single line chart
I'm creating a card using a multi-line chart and one of the requirement is I need to change the color for all the previous months indicating that these month were already actual.
For example: Oct, Nov and Dec must be put green colors then Jan onwards will stay orange color.
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
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 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
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive