7 Replies Latest reply on Apr 18, 2017 7:15 AM by Steve Czap

    How to get associating date for Max Value

    Steve Czap

      Hello Experts,

       

      I have a formula that finds the max value of my variable nicely by using, WINDOW_MAX (Max([Select RowCnt or ElapsedSecs]))

       

      I would like to capture the [Start Ts] date that corresponds with that max value above.   I've tried using the If-then and Case formulas but cannot find the right syntax that Tableau accepts.

       

      I'm looking for something like...

       

      If WINDOW_MAX (Max([Select RowCnt or ElapsedSecs])) Then day([Start Ts])

       

      Any assistance would greatly be appreciated.

       

      Thank you,

      Steve