Dynamic Segmentation

Customer is using a dynamic segmentation feature, problem is dynamic categorisation based on a time period.
When the average of the last 2 days is 10, that gets categorised as 20.
On the front end, when this average changes, they want it to be categorised differently, is that possible?
Best Answer
-
Would need to understand more about your data, but as long as the rules for what should belong to each category are clearly defined it shouldn't be a problem, is just a matter of creating the right CASE statement. The categorization could be performed either via ETL (if it's not meant to be responsive to filters) or Beast Mode, something like:
Categorized
CASE WHEN `average2days` = 10 THEN 20 ELSE 10 END
Clearly I don't expect you to have values for each possible option for the average so most likely you'll use ranges and look which one they match and have multiple WHEN statements for all the possible categorizations you need.
0
Answers
-
Would need to understand more about your data, but as long as the rules for what should belong to each category are clearly defined it shouldn't be a problem, is just a matter of creating the right CASE statement. The categorization could be performed either via ETL (if it's not meant to be responsive to filters) or Beast Mode, something like:
Categorized
CASE WHEN `average2days` = 10 THEN 20 ELSE 10 END
Clearly I don't expect you to have values for each possible option for the average so most likely you'll use ranges and look which one they match and have multiple WHEN statements for all the possible categorizations you need.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 89 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive