cjimenez

@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`) -…

in Help with Beast mode to calculate time in tier Comment by cjimenez June 2022

That worked, thanks @MarkSnodgrass

in Help with Beast mode to calculate time in tier Comment by cjimenez May 2022

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

in Help with Beast mode to calculate time in tier Comment by cjimenez April 2022

cjimenez Member

Comments