SYMPTOM:
In Strategy 9.4.1 and 10.x, "BandingC" and "BandingP" are functions grouping metric data into bands. Their definition and syntax is as follows:
Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
| Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
| Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
|
Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
| Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
| Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
|
Amazon Redshift ODBC Driver 1.0.8.x
Banding Typeband count (BandingC)band points (BandingP)DefinitionGroups metric data into a specified number of bands and assigns values to the resulting metric.Groups metric data into bands identified by boundary point values.SyntaxBandingC(M1, StartAt, StopAt, BandCount)
This function accepts four arguments:
|
BandingP(M1, Boundary1, Boundary2, Boundary3.…)
This function accepts arguments as follows:
|
|
Consider the following examples:
BandingC:
Create a metric with the following definition:
BandingC(Revenue, 1000000.0, 4000000.0, 3.0)
The Strategy Engine creates three bands. Group the Regions by revenue amount in increments of 1000000.0 (3000000.0/ 3.0), as shown below:
The display content bands the attribute 'Region' as follows:
- band1: 1000000<= Revenue < 2000000
- band2: 2000000<= Revenue < 3000000
- band3: 3000000<= Revenue < 4000000
