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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 26 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 653 γ²γγγε ±ζ