Chart X-axis range wise display

[#1]

Hi,

How can i display range in x-axis like(1-10,10-20,20-30......100) in Bar chart

Mydata is

SALESREPID     ORDERId

1                              100

2                              101 

1                              102

3                              103

1                              104

2                               105

in my data having total 2600 Orders

I want to display    count(SalesRepID)   in the above range wise

i am using =class(count(Total OrderID),50,'x')

it showing only one 2600<=x<2650

Please Help me,

Thank you.

[SreeniJD]

Use Class function. this will work for you

Sreeni

[stephenedberkg]

go to chart properties -> axis -> set minimum,maximum and step values

refer this attachment

[#4]

i want to display range in x -axis

not 0,10,20,30

0-10,10-20,20-30

like this

[gautik92]

have a look at this

[#6]

Please send me class function expression ,i am using trail version

[gautik92 · Accepted solution]

Data:

load

  *,

  replace(Class(ORDERS,10), '<= x <','-') as Range,

  Class(ORDERS,10) as GroupRange

Resident Sales;

[#8]

Thank you

Gowtham