Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SLA Calculation based on multiple criteria

Hi Community,    I really need help in finding the best approach to come to a solution to calculate the DATE DIFF days for each line/ #ref.  Calculate average of Date Diff days between the fol...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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!

 

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

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