2 Replies Latest reply on Oct 9, 2016 2:09 AM by Rowel Zantua

    How to calculate mode from an aggregated data?

    Rowel Zantua

      Hi everyone!

       

      I've already found/read forums on how to calculate mode in tableau but with the data that I have I can't make it work.

       

      Each 8 digit code may contain more than 1 value, as shown in the Detail view. I need to return the mode from the values of every 8 digit code.

       

      For the example below, 1.36 should be returned as the mode for the code 39011019.

       

      Mode.JPG