I need to create a chart which shows how many claims have been incurred within a Policy Month. i.e. Policy Inception Month = Policy Month 1 regardless of the actual month name. I am struggling to define this in my script. Ideally I also need to show the information by Policy Week and Policy Day too. Any ideas would be greatly appreciated.
So far I have defined the following in my script, but this does help when setting the months up as a chart dimension:
Month(PolicyInceptionDate) as PolicyMonth1,
Month(Addmonths(PolicyInceptionDate,1)) as PolicyMonth2,
Month(Addmonths(PolicyInceptionDate, 2)) as PolicyMonth3,
Month(Addmonths(PolicyInceptionDate, 3)) as PolicyMonth4,
Month(Addmonths(PolicyInceptionDate, 4)) as PolicyMonth5,
Month(Addmonths(PolicyInceptionDate, 5)) as PolicyMonth6,
Month(Addmonths(PolicyInceptionDate, 6)) as PolicyMonth7,
Month(Addmonths(PolicyInceptionDate, 7)) as PolicyMonth8,
Month(Addmonths(PolicyInceptionDate, 8)) as PolicyMonth9,
Month(Addmonths(PolicyInceptionDate, 9)) as PolicyMonth10,
Month(Addmonths(PolicyInceptionDate, 10)) as PolicyMonth11,
Month(Addmonths(PolicyInceptionDate, 11)) as PolicyMonth12,
