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.

Find more posts tagged with

Comments

MarkSnodgrass

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.

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:

Hope this helps.

DataMaven

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`)))