I have a table like this as below. This is just a sample 3 records
ID
OrderDate
FulfillementDate
1
4/1/2017
4/10/2017
2
5/7/2017
5/11/2017
3
5/13/2017
Using the above we have created a Master Calendar from 4/1/2017 to 5/13/2017 and linked these tables.
My requirement is to find out Age and Age bucket of each ID until it was fulfillled . The age will be CalendarDate - OrderDate...
Lets say we have couple of Age Bucket 0-4 Days and > 4 Days so ID 1 was in 0-4 Days bucket as 8th April 2017 but it was shifted to >4 Day.i want to show this in trendchart as we want to know how many IDs where in these age buckets as on that calendar date
