Is there a way to reference a segment in a BeastMode?

Is there any way to reference a Segment within a BeastMode formula? For example, I want to show the difference between a filtered total and the segment (which excludes filtering). Below is the BeastMode.
Here is the segment definition:
The Do Not Filter columns are part of our organization tree. We want to see the difference between the filtered part of the organization and compare against the org without any applied filters.
When applied to a chart it looks like this:
I am trying to build a single value card that will show the difference between these two. Domo has both calculation results available (because it's displaying both) but I don't know how to reference the segment in a formula.
It would be really messy to try to add this into the dataflow layer because of the number of org tree nodes that we have.
Any ideas would be appreciated.
Answers
-
Hi @kofagerburg
Segments aren't available within a beast mode. You could try to use a DataFlow to attempt to aggregate all of your data and then stack it / append rows with your dataset such that you now have an "ALL" row. You'd need to make sure though to include the ALL value when doing your filtering. You'd then want to use some beast modes with a case statement to filter out the ALL for the filtered part of the organization and then use a beast mode to explicitly filter for ALL to get the metrics for all of the company. It's not the cleanest option but how you could possibly get around your issue.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@kofagerburg you might consider using the comparative fill gauge to show this difference. It has the ability to compare the difference between two different fields, which is what you are wanting to do. Here's the KB article for it.
https://domohelp.domo.com/hc/en-us/articles/360042924414-Comparative-Fill-Gauge
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive