Segments
Hi,
I have sales data by month, by country.
I would like a segment for sales data in Canada so I created a segment named Canada and added the filter for the Country Canada.
Am I right in thinking this should then be removed from the rest of the data and the country filter within the analyser?
At the moment Canada appears as a segment on my graph but the bottom line figure IS including them?
Anything I can check for this as I sure looking at the vids and examples it should be removed.
Thanks again for everyone's help.
Answers
-
Segments only creates a subset of your data but doesn't remove it from the original dataset.
If you need to you can create two beast modes to do the Canada filtering for each of your metrics
-- Canada CASE WHEN `Country` = 'Canada' THEN `Value` END -- All Others CASE WHEN `Country` <> 'Canada' THEN `Value` END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi,
Thanks. I think I was misinterpreting this part of the docs
I think the normal use case would be to have country as a series as well and the above means you need to name the segment Canada as otherwise you could get the data repeated and a line for each.
I was able to get the behaviour I needed by removing the Canada option from the Country Filter which meant Canada was no longer included in the non segmented data. (Although deselecting all countries in the quick filter may include it!)
The Beasts modes you posted also worka when added to the series instead of using the segments 👍️
Thanks again for your help
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
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive