1 Reply Latest reply on Sep 14, 2018 12:00 AM by Jeevan Krishna

    Show Percentage of Highlight Calculation in Dashboard

    Senthil Kumar P V

      Hi All,

       

      In the dashboard, i select/highlight a portion of the data, such as 2 customers out of 4 customers in the sheet. Then the other sheet would filtered only the data that I have selected.

       

      However, I want to show the percentage of the highlighted customers out of total customers in the data. It should show 50% for the above case. It means that there should be a calculation that would ignore the action of highlight to sum the total numbers of customers.

       

      Does anyone know how to achieve this? Thanks! Greatly Appreciated!

       

      attached the twbx.

        • 1. Re: Show Percentage of Highlight Calculation in Dashboard
          Jeevan Krishna

          Hi Senthil,

           

          I don't have the correct version of tableau to open your dashboard. I tried this using sample store data.

           

          I created 2 sheets

           

          Source sheet is a map view with all states(49 unique states in the dataset)

           

           

          Target Sheet - Where we show the %Highlighted.

          Created a calculated field

          and used it in sheet like this

           

          and created a dashboard with the 2 sheets. Added an action with Map as source and the other as target sheet.

           

           

          Now based on the no.of states selected, the %selected sheet displays the required value.

           

           

          Hope this helps.