Hi ,
I am looking for solution to calculate ageing for incidents which are active (open or closed) in selected time frame.
Example: following things I have to keep in consider
1. provide date filter with between option
2. calculate @startDate and @endDate from selected slicer value
3. Created date can be before @startDate but cannot be after @endDate
4. Closed date should be in between @startDate and @endDate or also null has to be considered (closed date is null means incident is still open)
5. wanted to calculate ageing for Incidents which are closed in between the selected date range = datediff(Create Date, Closed date, Day)
ageing for open incident by datediff(create date , @endDate, day) where create date can be before @startdate
Huddles are
when I use date slicer it is not allowing me to consider create date before @startdate , can anyone please suggest how do I restrict startdate filter for create date so that it should consider the incidents open from historical data.
