Merging Bar Graph Data Points

R_Laspina · November 2019

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!

Cartergan · November 2019

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 · November 2019

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 · November 2019

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

MarkSnodgrass · November 2019

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?

Merging Bar Graph Data Points

Comments

Categories