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

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 
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
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.4K Connect
 1.2K Connectors
 286 Workbench
 4 Cloud Amplifier
 6 Federated
 2.7K Transform
 91 SQL DataFlows
 583 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 645 Beast Mode
 36 App Studio
 33 Variables
 629 Automate
 159 Apps
 431 APIs & Domo Developer
 37 Workflows
 2 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 377 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 4 Software Integrations
 104 Manage
 101 Governance & Security
 6 Domo University
 15 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 93 Community Announcements
 4.8K Archive