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 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'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!