Frequency Distribution Chart

[#1]

At the moment I have a range of values ranging from 0 - 10,000 and what I'm trying to do is to sort these values in 500 increments so that i can then count the amount of times values fall under each respective banner and build a frequency distribution.

Random Values for Example:

1245

2144

567

267

3000

2567

And how i wan them sorted is :

< 500 = 1

500-1000 = 1

1000-1500 = 1

1500-2000 = 0

2000-2500= 0

2500-3000 = 2

The values I have are sourcing from a .csv file

The row name i am trying to sort is called DAYS, I have tried the following expression but it does not give me what i want

count(DAYS > 500 and DAYS <=1000) as '500-1000'

Any help would be much appreciated.

Thanks

[#2]

Hello Nick,

Try this in your expression:

=Class([DAYS], 500)