3 Replies Latest reply on Dec 2, 2018 4:16 AM by Zhouyi Zhang

    How to calculate mode (most frequent record) of times

    Chao Chen

      Hi,

      I have a set of data with results of race times for a number of individuals. I want Tableau to calculate the mode (the most frequently occurring item) of the "Race Results" by Gender. I've tried using rank(sum[number of records]),'desc') but I can't get the race results to act as a dimension..

       

      Here's what my data looks like now:

       

      before.png

       

      Here's what I want tableau to output:

       

      after.png

       

      Attached is the packaged workbook I am using