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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive