Select only a range of values from a Field as a bar chart dimension

[bauddin]

I have a field named as days to arrival which consists values between 0-170. I would like to make  a bar chart with days to arrival as a dimension but only for 0- 68 days.Is there any ways to set this range ?

[GaryGiles]

To use as a dimension, you could use the aggr() function, like this:

aggr(Only({$<[Days to Arrival]={">=0<=68"}>} [Days to Arrival]), [Days to Arrival])

[bauddin]

That works .Thanks a lot for your quick answer

 Could you please tell  can I extend its use for class groups which i created using "class(daystoarrival,2)" .Some of them are as follows:

[GaryGiles]

Yes, you can enclose the aggr() function in a class() function, like this:

=class(aggr(Only({$<[Days to Arrival]={">=0<=68"}>} [Days to Arrival]), [Days to Arrival]),2)

[bauddin]

Thank you so much!