Cumulative values for rolling 6 months based on date selected
I am trying to create a chart that gives me cumulative value for rolling 6 months based on the date selected.
My data has 4 types of status dates at Application level (There are also many more columns in the dataset). For example, an application can move from Status 1 to Status 2 to Status 3 to Status 4 on different dates. I want to add a common running date filter based on which the number of applications should be filtered (because neither of the 4 columns have exhaustive list of dates). For this, I imported another data file containing running date for a period of about 3 years and used it as filter (full_date).
I have also extracted the day out of each date as day_s1date, day_s2date, etc.
Based on the date selected, the output should show cumulative count of applications from month start date till that date for rolling 6 months. If I select 15/11/2018 from the filter, I need count from 1 to 15 for June'18 to Nov'18.
I have used this for Dimension =(Date(monthstart(full_date), 'MMM-YY'))