Find the percentage of count of value by category

Reply
Highlighted
White Belt

Find the percentage of count of value by category

Imagine there are 3 colums
Country column - USA, UK, FR

Purchase_status - Issued, Refund

Count of purchased status

 

The goal is to add 1 more column that shows the percentage of 'count of purchased status by country'.
How should we do that in the beast mode, thank you in advance everyone.

Highlighted
Red Belt

Re: Find the percentage of count of value by category

I find that getting something like a country total works best in the ETL. You can get the country totals by adding a group by and then joining back to your main dataset. It would look like this in the ETL. 

groupbyETL.PNG

If you didn't want to do that, have you considered using a Nested Bar card? It does a nice job of showing the information you are looking for. Mocking up some sample data based on what you described, it would look like this:

nestedbar.PNG

Hope this helps.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Tags (2)
Highlighted
Major Brown Belt

Re: Find the percentage of count of value by category

Mark's solution is what I do when the groups are fixed and can be calculated.  You can run into trouble with some filtering, though.  

 

I have found that creative use of the RANK function can be helpful.  

 

Here's a sample of one that you can start with and explore:

RANK() OVER (PARTITION BY `Category` ORDER BY (Sum(`Amount`)))

 

 

 

 

DataMaven
Breaking Down Silos - Building Bridges
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!