Skip to content

    • Magic ETL

    Magic ETL

    Find the percentage of count of value by category

    Member
    in Magic ETL

    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.

    Comments

    • Coach

      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.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Coach

      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
      **Say "Thanks" by clicking a reaction in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories