11 Replies Latest reply on Sep 18, 2018 4:51 AM by Chirag Gandhi

    View a certain percentage of data in a bar graph

    Chirag Gandhi

      Hi everyone,

       

       

      I have a bar graph in Tableau that displays the number of people within a department for the business they are in. For example, if they are in electronics, there will be different bars for people in repairs, sales, and so on. I want to make it so that the bar only displays departments within the business that are greater than 10% of the business. So if the total number of employees within electronics is 7000, and repairs has 750 employees and sales has 300 employees, the bar will only show repairs and aggregate the lower departments into a new column within the bar graph. I'm new to Tableau and am not sure how to do this. Any suggestions would be much appreciated.

       

      Thank you!