Automatic Date Slicer

[Prasadbabu]

Hi All,

I am facing one scenario when developing user requirment which tracks 

I need to capture 3 types of counts which will tell the Users about the status of bugs for every month. 
1. [Closed Bugs this Month]

2. [Newly Added Bugs this Month]

3. [Total Active Bugs Till Date]

[closed bugs count] : it will tell about the count of bugs which are closed in time frame selected. 
[Newly added Bugs Count]: it will tell the count of bugs that are  added in time frame selected. 
[Active Bugs]: Actuve bugs seen at a pirticular Date is [Bugs Added till that Date]-[Closed Bugs Till that Date]

My output should be some thing like it should show stacked bar graph for last 3 months. 

I have Implemented Logic Upto getting the [active], [Closed],[Newly Active]. I am getting [Newly Active],[Closed] from Dataset Directly just Created a just sum measure for them. But For [Active] I have created a Measure which will calculate it by using concept of Running totals. 

Here My problem is I am not able to show the correct [active count] for last 3 months.  if I use Relative Date filter in Filter section. I am not getting [Active] correct. May be reason is if data is filtered to show onlt last 3 months. Example: sep,aug,jul. it will not show data before those dates.  before July. if 5 bugs are logged in january and no bug is closed after that. [Active count] should show still 5 for all the months in future.  If I filter last 3 months; as there is no bugs logged in after january in this example I am not getting no data for selected 3 months. 


Can anyone help me on this how can we acheive a filter which calculate the [active] for the last 3 months even the actual data is not present in selected filter. Measure should be calculated irrespective of date filter for every month. but only the Latest 3 months should be shown in visual. 

1a.( Expected  overall graph)
1a.

1b. (Expected pirticualar Graph for better understanding): Here 
jul : 11 bugs are newly added. so Newly active = 11 ,Closed = 0, Active = 11-0 =11
aug: 1 bug newly added. so newly added = 1, closed=0, Active = (11+1) - (0+0) = 12. 
sep: 0 bugs added or closed so Newly added =0 ,closed=0 active = (11+1+0) - (0+0+0) =12

1b

1c. (result I am getting when I am trying to filter last 3 months of data by using relative date in filter section. (it will change to Aug,sep,oct in month of october) in below case I need to get 12 in september month but I am getting Blank.
1c

[Prasadbabu · Accepted solution]

got the solution. 

Thanks