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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive