Replicate Excel Formula by using Domo to Calculate 80/20
Hey there! I'm trying to apply the Pareto Principle to the following dataset I've attached using either Beast Mode, Magic ETL, or MySQL.
I want to replicate what is done in column "Bottom 25" in Domo but I'm at a loss.
I've used the following query, but it gives me whole numbers instead of what's displayed in the "Bottom 25" Column.
In the second image is a screenshot of what the following query provides me.
Using the Magic ETL, I have already created a new column called "users total" that is a constant sum of the "Users" column.
SELECT a.*, round(100*(SELECT COUNT(*) FROM `copy_of_test_xlsx` AS b WHERE b.`Users` <= a.`Users` ) / total.cnt,1 ) AS percentile FROM `copy_of_test_xlsx` AS a CROSS JOIN ( SELECT COUNT(*) AS cnt FROM `copy_of_test_xlsx`) AS total ORDER BY percentile DESC
The Bottom 25 columns was found by using the following:
"Audience Interest Score" =C2/(SUM(C:C))
"Bottom 25" =SUM(D$2:D2)
Is there any way to replicate this? Please and thank youuu
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board