10 Replies Latest reply on Jul 27, 2017 1:10 PM by Galen Busch

    Finding maximum occurrence of data (MODE)

    Abhishek Singh

      Hi Tableau users,

       

      I want to find the maximum occurrence of data of rows, in statistical terms its the mode of the row. I want to return the the value or highest mode.
      I will not able to share the data due to company policy but i am attaching the screen shot that what i need.

       

       

      In the given picture below i want to find the "mode" for baseline discount of each contract criteria. Currently i am doing the average of baseline discount but i want to return the value of baseline discount which have highest number of mode for each contract criteria.

       

      Hope i get the solution from this community.

       

      Thanks