Using BeastMode Calculate the 80/20 by Category
Out of all the domains, which 20% of all domains account for 80% of the Users?
There should be more than one domain I think that account for that 80/20.
In addition, how can I measure that distribution difference?
I'm trying to this strictly in DOMO, but since I'm new, the struggle is real.
Best Answer

if i understand your question, to break it into pieces you should start with:
"what percentage of the users does each domain account for" so you need a percent of total calculation.
then you want to order your domains by percent of total ascending
then you want to keep all domains where the cumulative sum of 'percent of total' is <= .8
i think you can accomplish this with a dataset view or by preaggregating your data in Magic ETL 2.0
what happens if you have
Domain A = 75% of users
Domain B = 20% of users
Domain C = 5% percent of users.
What is your answer for 'which domains account for 80% of the users?'
If your answer is A + C the logic becomes much more complicated, b/c effectively you're trying to find the combination of values that gets the closest to .8% which is a logic problem that would be much harder to encapsulate than the easy answer just "A." or maybe "A + B"
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
Answers

if i understand your question, to break it into pieces you should start with:
"what percentage of the users does each domain account for" so you need a percent of total calculation.
then you want to order your domains by percent of total ascending
then you want to keep all domains where the cumulative sum of 'percent of total' is <= .8
i think you can accomplish this with a dataset view or by preaggregating your data in Magic ETL 2.0
what happens if you have
Domain A = 75% of users
Domain B = 20% of users
Domain C = 5% percent of users.
What is your answer for 'which domains account for 80% of the users?'
If your answer is A + C the logic becomes much more complicated, b/c effectively you're trying to find the combination of values that gets the closest to .8% which is a logic problem that would be much harder to encapsulate than the easy answer just "A." or maybe "A + B"
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 
Oh the way you worded this is so much easier to comprehend.
I was definitely looking at this in a more complicated mindset.
Thanks so much!
0
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 569 Datasets
 2K Magic ETL
 3.4K Visualize
 2.4K Charting
 601 Beast Mode
 15 App Studio
 29 Variables
 600 Automate
 151 Apps
 418 APIs & Domo Developer
 29 Workflows
 2 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 363 Distribute
 99 Domo Everywhere
 262 Scheduled Reports
 2 Software Integrations
 98 Manage
 95 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive