
1. Re: Create inclusive bins on axis
lenaic.ridinger Nov 3, 2016 8:41 AM (in response to amulya.sharma)Hi amulya.sharma,
Dimensions partition data rows so that each data row is associated with exactly one member of the dimension. So you can't use a single dimension to accomplish your goal. Adding more dimensions won't help since that will just partition the data at a finer level of granularity.
So you need another approach that doesn't use dimensions for the Days field. What else can you use? The only other significant choice is to use measures. (Attributes are just another variant of measure in this regard)
So make a calculated field Records_60_days_or_more defined as
count(if Days >= 60 then 1 end)
Make similar ones for Records_0_days_or_more, Records_90_days_or_more etc.You can make the new fields discrete or continuous depending on how you want to present them.
I would consider renaming your "bins" something like 0+, 30+, 60+, since you really aren't using the upper bound at all  like an accounts receivable aging report.
Finally, if the field Days can be null, you should consider how you want to modify these calculations. The definitions above ignore any records with null Days. If instead you want to treat a null number of Days as either zero or infinity for these calculations, then you can make some adjustments using functions like ZN(), IFNULL() or ISNULL()