SLA Calculation based on multiple criteria

[Anonymous]

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 follwoing two dates.

Table:

t_Data

Fields: 

- Date_Requested

- Date_Presented

- #ref_date

Criteria to consider:

- 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

Data Sample:

https://we.tl/t-0KAMMjURHq

Thank you guys. 

[Anonymous]

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 follwoing two dates.

Table:

t_Data

Fields: 

- Date_Requested

- Date_Presented

- #ref_date

Criteria to consider:

- 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

Data Sample:

https://we.tl/t-0KAMMjURHq

Thank you guys.