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
parry2k's avatar
parry2k
Super User
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous in this whole time, it is first time you mentioned what is "Selected month", now it make sense

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k my apologies for the confusion. Would you be able to help me build the SLA column with the criteria mentioned? 

    Thanks a lot! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    @v-xicai can you support please?

    Thanks.