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