Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SLA Calculation based on time 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 follwoi...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Greg, Community, 

 

Please have a look at the link (sample data) and also the criteria, here below: 

https://we.tl/t-RWyqc2H6s2

- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider 

- If selected Date_Requested is > selected month in which #ref selected is, do not consider

- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider

 

Thank you! 

Nelson

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Greg_Deckler  I do need your expertise. 

Thank you.

Anonymous wrote:

Hello Greg, Community, 

 

Please have a look at the link (sample data) and also the criteria, here below: 

https://we.tl/t-RWyqc2H6s2

- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider 

- If selected Date_Requested is > selected month in which #ref selected is, do not consider

- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider

 

Thank you! 

Nelson