I want to create an Aging histogram on date columns – normally used on invoice aging. Can anyone kindly help me with an example please.
Something like Buckets for
Within 1 Year,
Between 1 and 2 Years
Between 2 and 3 Years
Between 3 and 4 Years
Greater than 5 Years
Can the Bucket Size and be Parametrized?
If you create a calculation something like
datediff('year',[Date], today()) you could use the histogram to bucket this. Or you could create a full calculation around this to do this:
if datediff('year',[Date],today())<1 then "Within One Year"
elseif datediff('year',[Date],today())<3 then "Between .....