3 Replies Latest reply on Sep 14, 2016 7:37 AM by David Li

    How to get Top 5 Projects based on count of a measure.

    Rahul Nambiar

      Hi,

       

      Needed some quick knowledge on how can we get top n (Top 5) Projects (dimension values)with the most defects.

       

       

      I have tried with tried the Top N option in the  filter which where I can select top n Projects (Tracks) by my formula of CountD(Defect ID) but that is not working as expected as it is also showing me all Projects including those which are not having defects at all.

      Can there be a way this can be done.

      Please let me know if any additional info is required.

       

      Thanks,

       

      Rahul.

       

      Message was edited by: Rahul Nambiar I want to show these projects or top 5 tracks in a single cell as above. Also I am using Tableau desktop 8.2 for development.