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!

Comments

  • 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%

  • MarkSnodgrass
    MarkSnodgrass 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):

    StudentCredits Toward ProgramCredits Required
    Jim57
    John67
    Joe77
    Sue87
    Bill97

    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. 

    creditsbar.PNG

    Is this what you were hoping to achieve?

This discussion has been closed.