Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Data:
load
*,
replace(Class(ORDERS,10), '<= x <','-') as Range,
Class(ORDERS,10) as GroupRange
Resident Sales;
Use Class function. this will work for you
Sreeni
go to chart properties -> axis -> set minimum,maximum and step values
refer this attachment
i want to display range in x -axis
not 0,10,20,30
0-10,10-20,20-30
like this
have a look at this
Please send me class function expression ,i am using trail version
Data:
load
*,
replace(Class(ORDERS,10), '<= x <','-') as Range,
Class(ORDERS,10) as GroupRange
Resident Sales;
Thank you
Gowtham