Duration (In Hours) Excluding Weekends

Looker Q&A Looker
1

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

2

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