Forum Discussion
SLA Calculation based on multiple criteria
parry2k Thank you for reaching out and try to help me.
Sample of the real dates and refs :
based on this dataset, the criteria to achieve this SLA metric is:
- If selected Date_Presented is < beginning of the quarter which #ref selected is, do not consider (don't show rows)
- If selected Date_Requested is > selected month in which #ref selected is, do not consider
- If (Date_Requested > (end of the month of #selected month- 21 days) & (Date_Presented > End of the month of #selected month) , do not consider
Anonymous you alredy shared that file, thanks for sharing again Based on your data in the sheet, can you put another sheet with expected output.
parry2k I have commented in the sheet, hope it clarifies. Once again, thank you so much!
Data :
Anonymous what you mean by "selected month" in following
2) 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.Hi parry2k
Basically, this will be placed in the main Dashboard, and the main filter there will be "Date", therefore what I would like to achieve is basically if a manager selects "March", the SLA 01 will have those criteria in consideration based on the selected month. Please do let me know if this make any sense ?
Thank you for your help!
Nelson
Anonymous in this whole time, it is first time you mentioned what is "Selected month", now it make sense