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


      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:




      Here's what I want tableau to output:




      Attached is the packaged workbook I am using