How to conditionally format color on Stacked Bar + Symbol Chart
I have a dataset that looks like this:
Each row is a day an employee was active. If this was the employee's first day, Hire Flag = 1, else 0. If this was the employee's last day, Term Flag = 1, else 0. I am building a chart to show hires, terms and net over time. It looks like this:
I am using a Symbol + Stacked Bar chart type. Each pair of bars represents a day. The light bar is sum(Hire Flag), the dark bar is sum(-1*Term Flag). Net is a beast mode that looks like this:
I want to conditionally color the net symbol. If less than 0, red; if greater than or equal to 0, green. I set up my color rules like this:
However, this is not rendering in the chart as I expected. In the picture of the chart above, you see that the symbols remained blue. Yet, in the legend there were series added for my color rules, but those are not visible on the chart.
Any ideas on how to set up my color rules so this renders correctly? Thanks!
Best Answer
-
I tried setting color rules on a basic stacked + symbol card and it looks as though the color rules don't apply to symbols. They only apply to the bars. That is an unfortunate limitation. I would submit this in the Ideas Exchange section of the Dojo to make that an option. Not sure why they would limit it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
I tried setting color rules on a basic stacked + symbol card and it looks as though the color rules don't apply to symbols. They only apply to the bars. That is an unfortunate limitation. I would submit this in the Ideas Exchange section of the Dojo to make that an option. Not sure why they would limit it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thanks @MarkSnodgrass . I've submitted the idea here.
https://dojo.domo.com/discussion/52689/conditional-formatting-in-symbol-stacked-bar-chart/p1?new=1
0
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
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 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