add_dynamic_segmentation
Create a dynamic segmentation measure that classifies entities by measure value against band boundaries and returns the count of entities in the selected segment.
Instructions
Generate a dynamic-segmentation measure that classifies an entity by a measure value against a disconnected band table (left-closed, right-open bounds). Returns the count of entities in the selected segment.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| measure | Yes | the measure to classify on, e.g. Total Sales | |
| sessionId | Yes | ||
| entityTable | Yes | entity / home table | |
| lowerColumn | Yes | lower-bound column name on the band table | |
| upperColumn | Yes | upper-bound column name on the band table | |
| boundaryTable | Yes | the boundary/band table name | |
| segmentColumn | Yes | segment-label column name on the band table | |
| granularityColumn | Yes | entity grain column as Table[Column], e.g. Customer[CustomerKey] |