Skip to content

    • Archive

    Archive

    Line Percent of Total Chart

    Member
    in Archive

    I'm struggling trying to figure out if Domo can handle creating a line chart that calculates the percent of total for the value, then show those values as percentages on a line chart. I've been searching around forever and have tried using %_PERCENT_OF_TOTAL as a data value label, but the problem there is that doesn't change the Y axis scale, it still shows the count as the scale, not 0-100%. By the title of property, I'd imagine that makes sense since it is just configuring the data labels. 

     

    My domo dataset columns are quite simple, just Date, Type (A,B,C) and Count. I can figure out how to do this quite simply in Excel, but not seeing an easy way to do this currently in Domo. 

     

    I've attached a quick sample image of what I'm trying to accomplish. Is this even possible in Domo?

     

    Line Chart Example.png

     

     

    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

    Comments

    • Domo Employee

      You should be able to accomplish this with a beast mode calculation:

       

      You will need to make a separate calculation for each type.

       

      Type A:

      sum(case when `Type` = 'Type A' then `Count` end) / sum(`Count`)

       

      Type B:

      sum(case when `Type` = 'Type B' then `Count` end) / sum(`Count`)

       

      Type C:

      sum(case when `Type` = 'Type C' then `Count` end) / sum(`Count`)

       

      You should then be able to use the Line Chart.  Just put `Type A` for Y-axis, and `Type B` and `Type C` in as SERIES.  

    • Member

      This original question was posed 4 years ago.

       

      Is there a more modern way to accomplish this without creating a unknowable number of beast-mode calculations?

    • Coach

      window function.

       

      sum(amount) / sum(sum(amount)) 

       

       

      https://www.youtube.com/watch?v=eifSYZIcPzg&t=868s

      Jae Wilson
      Check out my 🎥 Domo Training YouTube Channel 👨‍💻

      **Say "Thanks" by clicking the ❤️ in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    This discussion has been closed.

    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