Similar to Class function but returning the number (Count) of elements in the range

[#1]

Hi Guys,

Let's say I have the field SingleAverage with the values as shown below.

SingleAverage

70

71

72

73

74

74.5

75

I also have a variable vStep.

I need to create a chart DIMENSION that shows the number of values between steps (including upper limit).

In example, if vStep is 2, the DIMENSION should has

2 (70,71),

2 (72, 73)

3 (74, 74.5, 75)

Pretty similar to Class(SingleAverage, vStep, 'x'), but returning the count of values instead of a string describing the ranges.

Thanks in advance,

Aldo.

[Clever_Anjos]

1st step -

Create a dimension in your script with

load

          subfield(Class(Expression1,10),' ', 1) as yournewdim

, [another fields]

Resident your_Data .

2st step -

Use this yournewdim  inside your app and use count(yournewdim) as your expression.