Forum Discussion
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...
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