White Belt

## 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!

Highlighted
Brown Belt

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

Highlighted
White Belt

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!

Highlighted
White Belt

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

Announcements