Average time to response but how do I not include weekends?

deona720

I am making a dashboard summarizing some trends with Jira tickets and trying to create a metric card that shows the current average time to first response, I am using this formula (which I think I got off this forum):

CONCAT(
case when ROUND((((86400DATEDIFF([CHART] Date of First Response,Created))+(time_to_sec(TIMEDIFF([CHART] Date of First Response,Created))))/60)/60 - 0.5, 0) <= 9 then '0' else '' end,
ROUND((((86400DATEDIFF([CHART] Date of First Response,Created))+(time_to_sec(TIMEDIFF([CHART] Date of First Response,Created))))/60)/60 - 0.5, 0))

But we are finding out the average is quite high because of the fact that weekends will be an extra 48 hours to first response. How can I make this only weekdays?

ColemenWilson

You can use the DAYOFWEEK() function to identify and remove weekends - days 1 and 7 (saturday and sunday)

CASE WHEN DAYOFWEEK(`YourDateField`) NOT IN(1,7) THEN Your beastmode END