Beast Mode Sums not working, leading to strange sorting.
Hi there! I have 3 series made with Beast Mode:
Series 1 = sum(`a`) + sum(`b`) + sum(`c`)
Series 2 = sum(`d`) + sum(`e`) + sum(`f`)
Series 3 = sum(`a`) + sum(`b`) + sum(`c`) + sum(`d`) + sum(`e`) + sum(`f`)
I have Series 1 and Series 2 (blue and green) stacked on top of each other, and I'd like to sort by their combined totals. I try to do this by sorting by Series 3 (desc). However, if Series 1 or Series 2 is = 0 (e.g. there is no sum), then the calculated total is also 0. This leads to some strange sorting: For Xvalues where either Series 1 or Series 2 is 0 (no data for Series 1 or Series 2), the sorting is seemingly random. Do I need to check for 0s in my Beast Mode sum?
Thanks in advance!
Best Answer

I presume a  f are individual field values? I presume you've created a distinct Beast Mode for Series 3 to sum all of the a  f values? Are you creating a distinct beast mode calcs for your Series 1 & 2 results, or doing that as a CASE since the results a  c and d  f are mutually exclusive?
Then in SORTING, are you adding Series 3 / SUMDESC as your primary sort?
If you are creating a single Beast Mode to handle Series 1 & 2, I would recomment doing them separately, and then bringing in both Series into your Values section. They'll still stack with the correct card type selection. Splitting them was the only way i was able to overcome this problem.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1
Answers

Here's a link to an older thread on this topic.
https://dojo.domo.com/t5/CardBuilding/StackedBarChartSortingIncorrectly/mp/12433#U12433
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1 
I figured out that the problem comes when summing null values. Added a couple IFNULL() statements to my Beast Modes for the fix. Thanks for your help! ?
0
Categories
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有