Comments
-
@MarkSnodgrass thanks again for your guidance. While I was able to calculate time difference in business hours, I've been unable to accurately validate my data, as I never accounted for weekends. This is what I was able to put construct thus far: CASE WHEN `events rank` = 1 THEN ROUND(((UNIX_TIMESTAMP(`Tier Transition`) -…
-
That worked, thanks @MarkSnodgrass
-
@MarkSnodgrass I've looked into TIMEDIFF function, but as you mentioned, it calculates based on 2 different columns. In my example above, Time in Tier 2, the timestamps fall within the same column and this is where I'm struggling to construct a formula.
