HELP CENTER

HELP CENTER

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Dojo
- :
- Using Domo
- :
- Card Building
- :
- Merging Bar Graph Data Points

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-20-2019
11:20

11-20-2019
11:20

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-20-2019
03:36

11-20-2019
03:36

Re: Merging Bar Graph Data Points

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-21-2019
06:04

11-21-2019
06:04

Re: Merging Bar Graph Data Points

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-26-2019
06:34

11-26-2019
06:34

Re: Merging Bar Graph Data Points

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

Announcements