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!

Find more posts tagged with

Comments

Cartergan

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

R_Laspina

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!

R_Laspina

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

MarkSnodgrass

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?

SampleCredits.xlsx