Waterfall Graph  ordering
I am having some trouble with the ordering of the bars in my waterfall graph. I am using the same data set to create two different waterfall graphs (Filtering by dept.) and although the information is portrayed in the same format in my dataset it switches the order around in the two different graph. I am reconciling sales from 2015 to 2016 based on Price, Volume and Mix. So the graph should have 5 bars = 2015 Sales / Price / Mix /Quantity / 2016 Sales. I did not include the 2016 sales in my dataset but it is being reflected correctly in the graph.
When I run the Graph for Dept A is drops the Quantity field and when I run it for Dept B it switches the order around that Quantity is first instead of 2015 Sales? The dates in the data set run sequentially in the order I wish to portray the information but still it is not reflecting correctly.
Any suggestions/tips would be appreciated.Thanks
Best Answer

Hey @CMartinaglia 
You can manually set the sort order with a Beast Mode calculation, something similar to:
CASE
WHEN `Dimension` = '2015 Sales' THEN 1
WHEN `Dimension` = 'Price' THEN 2
WHEN `Dimension` = 'Mix' THEN 3
WHEN `Dimension` = 'Quantity' THEN 4
WHEN `Dimension` = '2016 Sales' THEN 5ELSE 0
ENDTake a look at the the sample Beast Mode calcualtions in the knowledge center.
Hope this helps!
2
Answers

Hey @CMartinaglia 
You can manually set the sort order with a Beast Mode calculation, something similar to:
CASE
WHEN `Dimension` = '2015 Sales' THEN 1
WHEN `Dimension` = 'Price' THEN 2
WHEN `Dimension` = 'Mix' THEN 3
WHEN `Dimension` = 'Quantity' THEN 4
WHEN `Dimension` = '2016 Sales' THEN 5ELSE 0
ENDTake a look at the the sample Beast Mode calcualtions in the knowledge center.
Hope this helps!
2
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 286 Workbench
 4 Cloud Amplifier
 5 Federated
 2.7K Transform
 91 SQL DataFlows
 580 Datasets
 2.1K Magic ETL
 3.5K Visualize
 2.4K Charting
 623 Beast Mode
 28 App Studio
 33 Variables
 612 Automate
 156 Apps
 422 APIs & Domo Developer
 32 Workflows
 2 DomoAI
 29 Predict
 12 Jupyter Workspaces
 17 R & Python Tiles
 373 Distribute
 104 Domo Everywhere
 266 Scheduled Reports
 3 Software Integrations
 101 Manage
 98 Governance & Security
 4 Domo University
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 91 Community Announcements
 4.8K Archive