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