Averaging multiple Percentile rankings
Hi Everybody.
I am stuck with a problem. First of all, thanks to Jae Wilson for the percentile rank video. It help me solve one part of the problem. My data looks lik attached
The data is pulled from Google Analytics and modified using Magic ETL. It contains page title, Month, and other metrics. The task on hand is to rank Page views, Organic search and new user rate for every content published in last six months. the ranks need to work for all content grouped by page title and also page titles + month/ so if somebody choose to see a particular month content rank they can see it. Now this is resolved, at least I think it is. the current output looks like this.
I have used following formula to calculate rank through beast mode
(sum(MIN(1)) over (partition by `Month_ text` order by (sum(`New Users`) / SUM(`Users`)) asc)
/
sum(MIN(1)) over (partition by `Month_ text`)) * 100
Now, another task is to find an average of all three of these segmented by month. So when filtered by month they can see the score of that filtered period. something like:
( avg ( new user rate percentile rank) + avg ( organic search percentile rank) + avg ( pageview percentile rank) ) / 3.
Any suggestions are welcom. Much appreciate your help with this.
Kind regards,
Vishesh
Answers

If I'm understanding your issue correctly, the issue is that you want to compute a beast mode of a beast mode. My recommendation is to use Magic ETL for (at least) your first computation and then you can compute the second formula either in another Magic ETL tile or in a Beast Mode. If you use the formula tile in Magic ETL beta, this should be pretty straightforward. Hope this helps.
1
Categories
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有