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.
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.0
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 88 Cards, Dashboards, Stories
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive