Bar Chart - side-by-side comparison of category average and individual item?

Hello All,
I'm interested in building the following type of graphic.
Let's say I have a category such as 'Truck' and want to calculate the average cost for all categories 'Truck'.
And let's say I would like to have a side-by-side comparison of that average compared to a particular 'Truck'.
I'm having a tough time achieving this without hardcoding values.
Any advice would be appreciated.
Comments
-
You can do this easily in Magic ETL. It would look something like this.
Perform a group by of all trucks to get the totals.
Join it back to your main dataset. You will then have that All Trucks total next to your individual truck total as another column.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Instead of JOIN'ing the data as @Mark proposes, I would APPEND the data to itself. Then replace the "TruckID" value with "Truck_Total"
this way your dataset will still respond to filters and you don't have to do weird math.
sum(case when truck_id <> 'truck_total' then amount end) / sum(case when truck_id = 'truck_total' then amount end)
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Great thanks for the responses guys. I'll give it a shot!
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive