2 Replies Latest reply on Mar 8, 2016 3:18 AM by Tharashasank Davuluru

    Find Max from Count Aggregate Function

    Karthik Venkatraman

      Hi,

       

      I have a requirement in which i need to find count the events for the subject with the highest number (max) of events at each site.

       

      I started with finding the count of events per site. However when i try to find the max of the events count, i am not able to do that as tableau doesn't allow me to do an aggregate function over an aggregate function.

       

      Is there a way to do this.

       

      I have attached the data as well as the workbook for reference.