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,