Duration (In Hours) Excluding Weekends

[Darren_macdonal]

Hi Community, 

Wanting to pick your brain on a way to do a duration between two Timestamps, but excluding weekends. 

For context, we are trying to track quote turnaround time and we have a KPI of response being less than 24hrs, but if the quote request comes in on a Friday 15:00 for example, that would then be required by Monday 15:00. 

Thanks in advance

[IanT]

add week_of_year to the timeframes of the start and end dates

new measure:

sql: ${duration_in_hours} - ((enddt_week_of_year - startdt_week_of_year)*48)

Some edge cases you will need to think about in there such as if it bridges a year end (careful with week numbers here as its not always 52) - https://www.epochconverter.com/weeks/2021