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.