Line Percent of Total Chart

Reply
Highlighted
White Belt

Line Percent of Total Chart

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

 

 

Highlighted
Black Belt

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.  


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Highlighted
Yellow Belt

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?

Highlighted
Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Original Domo post: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Calculate-average-time-to-accumulate-to-a-value/m-p/50668 // more windowed function vide...
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.