Group by Percentage
Hi there!
I'm trying to figure out how to get the percentage of rejected x-ray images by reject reason. I built a simple ETL that gives me the count of rejected images by reason for each type of x-ray (body part) along with the total # of x-rays for that body part (Acquisition).
I'm stuck on how to get the % of rejects per body part and could use some help.
Many thanks! C
Best Answer
-
Works perfectly! Thanks so much for your help!
0
Answers
-
I would suggest adding another group by that aggregates by body part and then join it back to your initial group by. You can then use the formula tile to calculate the percentage. If you are unaware, you can have multiple lines go out from any tile so that you can perform different operations such as this and then join them back together.
**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.3 -
Works perfectly! Thanks so much for your help!
0 -
@user17774 Glad that worked for you. If you can accept any answers that helped you, that will help others in the community.
**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.2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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