Forum Discussion
SLA Calculation based on multiple criteria
v-xicai parry2k thank youso so much!
It really works the way it's supposed to.
As you can see below, I have filtered out Saturdays+ Sundays.
However, the DATEDIFF between "Date Demande" & "Date Presented" is still summing all days (including weekends and holidays). How can I tackle this, even if I have the filter DayofWeekNumber set only for weekdays.
Thank you !
Hi Anonymous ,
After you created measure Filter, please put measure Filter to the Visual Level Filter of table visual displaying column Datediff, and select option "is not blank".
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xicai ,
"please put measure Filter to the Visual Level Filter of table visual displaying column Datediff, and select option "is not blank" - When I do this, it filters my table to only 12 rows (which is incorrect ). I checked the relationships and all seems to be fine.
One other thing that I would need to do is to get the DATEDIFF excluding weekends, can you advise please?
Thank you!
Hi Anonymous ,
So the criteria as you said is to filter the weekends out, right?
do not consider this row (for eg: FP#00119) for the selected month if:
- Date_Presented is > end of the selected month
- Date_Demande is > end of the selected month - 21 Days
- Date_Presented is < Beginning of the Quarter that the selected month belongs to.
Best Regards,
Amy
This criteria works fine but the DATEDIFF calc is summing up all days, including weekends.
I have created a isWorkDay flag, however it doesn't seem to work, Can you help me overcome this?
Thanks v-xicai