Percent comparison chart with more than 100%
I hope I explain this correctly. I am trying to get a stacked chart where my field 'Estimated Hours' = 100% and my 'Actual Hours' is a percentage of 'Estimated Hours'. The Estimated Hours field has different values across the chart so I didn't think they'd all be even at the top. I'd also like to show it where if the Actual Hours is less than the Estimated, that the actual will show as green but if it is more than the estimated, that the amount above the 100% line shows as red. I've tried a few different charts for this. I'm attaching images of what I currently have but I know its wrong. Can someone point me in the right direction?
Comments
-
Is anyone able to help out with this request?
0 -
Hi jlazerus,
I think an easier way to go would be to use a Grouped Bar Card, with one column being the Estimated Hours, and the second being Actual Hours, that way when viewing the card, it will quickly be apparent if the actual hours are larger or smaller than the Estimated Hours.
As well, you will need to write a BeastMode to be able to make the Color Rule work properly. An example of this beast mode would be:
CASE
WHEN
`Actual Hours` > `Estimated Hours`THEN 1
ELSE 0
END
Then in the Color Rule, if (BeastMode Name) is 1, then Red, otherwise Green.
I hope that helps you with this card!
Josh Thorn
DOMO Support
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive