Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.