Merging Bar Graph Data Points

I am hoping someone can help me with a road block I am running in to.

Here is the background.  I have created a Domo card that shows progression through a certificate program.  I had to create a Beastmode calculation that divided # of credits required by # of credits toward program.  A couple students have more than the needed credits toward their program, which puts them at over 100%.  I have tried every calculation in the book, but I cannot get those students who are over 100% to merge into the students who are exactly at 100%.  My bar graph shows two columns of "100%", but when I drill into the data, every student at 100% or above shows up for both columns.  Any help would be much appreciated!

• Would you mind posting the beast mode calculation you have come up with?

I'm thinking you might be able to do something along the lines of:

CASE WHEN (beast mode calculation >= 100%) THEN 100% ELSE (beast mode calculation) END

• Sure, here is the current calculation:

CASE
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 0
THEN '0%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 10
THEN '10%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 20
THEN '20%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 30
THEN '30%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 40
THEN '40%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 50
THEN '50%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 60
THEN '60%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 70
THEN '70%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 80
THEN '80%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 90
THEN '90%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 = 100
THEN '100%'
WHEN Round(`# of Credits Towards Program`
/
`# of Credits Required`, 1) *100 > 101
THEN '100%'
END

I've tried various other ways as well, such as after the 90% calc just saying Else '100%'.  I can't seem to get all the 100%s to merge into one bar.

Thank you!

• I tried the above suggestion and it did not merge the two groups together.  I'm still seeing two bars with 100%

• Portland, Oregon 🥷

I think I created what you are looking for. Here is what I did.

I created some sample data that looks like this (I've also attached the file):

 Student Credits Toward Program Credits Required Jim 5 7 John 6 7 Joe 7 7 Sue 8 7 Bill 9 7

I then created a beast mode field called CreditPctRange that contains this:

`(CASE WHEN (`Credits Toward Program`/ `Credits Required`) < .1 THEN '0%'WHEN (`Credits Toward Program`/ `Credits Required`) < .2 THEN '10%'WHEN (`Credits Toward Program`/ `Credits Required`) < .3 THEN '20%'WHEN (`Credits Toward Program`/ `Credits Required`) < .4 THEN '30%'WHEN (`Credits Toward Program`/ `Credits Required`) < .5 THEN '40%'WHEN (`Credits Toward Program`/ `Credits Required`) < .6 THEN '50%'WHEN (`Credits Toward Program`/ `Credits Required`) < .7 THEN '60%'WHEN (`Credits Toward Program`/ `Credits Required`) < .8 THEN '70%'WHEN (`Credits Toward Program`/ `Credits Required`) < .9 THEN '80%'WHEN (`Credits Toward Program`/ `Credits Required`) < 1 THEN '90%'ELSE '100%' END)`

I used a bar graph and put the beast mode field (CreditPctRange) in the X-Axis. I made the Y-Axis use the Student field and used the COUNT aggregation and then also put the Student name in the series. It resulted in a graph that looks like this.

Is this what you were hoping to achieve?

**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.
This discussion has been closed.