8 Replies Latest reply on Apr 10, 2018 6:54 AM by Hannah Keith

    Top X rank filter not working properly

    Hannah Keith

      Hi,

       

      I'm trying to allow users to toggle between the top 5,10,15 or all loss reasons (Select Loss Level parameter). I'd want it to show the top x reasons based on the sum of loss hours across the years selected. Currently when I filter for top 20 by sum of loss hours I'm getting 11 loss level reasons and 18 horizontal bars (loss reason and year combo). I'm having trouble figuring out how Tableau is calculating this way and how to fix it. All help appreciated!

       

      I'm working on the "Downtime Reasons - Full Loss Abbrev" tab of the attached workbook