4 Replies Latest reply on Dec 6, 2016 5:38 AM by D Barnetson

    Coloring for entire fields in a worksheet

    koushik.neelakantha

      Hello Everyone,

       

      Please find the below screenshot. I just want to have the coloring for entire fields in a particular worksheet.

       

       

       

      If speciality =centralized JNJ then green elseif speciality =centralized competitor then red else amber.

       

      I am using Version 9 tableau desktop.  Excel file has been provided

       

      Regards,

      Koushik.

        • 1. Re: Coloring for entire fields in a worksheet
          D Barnetson

          Hi Koushik,

           

          I'm my example I have used a technique that involves creating dual axis's using the AVG Number of Records which allows you to place your dimensions on the field for you to be able to color them based on a case statement.

           

          Category was used for color in my example, but in your case, it would look something like this:

           

          case [speciality]

          when 'centralized JNJ' then 'green'

          when 'centralized competitor' then 'red'

          else 'amber'

          end

           

          I have attached a packaged workbook (v9.0)

           

          Hope this helps.

          Don

          1 of 1 people found this helpful
          • 2. Re: Coloring for entire fields in a worksheet
            D Barnetson

            Hi Koushik,

             

            I've tried recreating the same approach with your data set, but it doesn't seem that the data is consistent.

             

            The values for 'Specialty' do not show as you had described in your calculation in your post.

             

            You may have to create some logic to determine those values. Currently, 'Specialty' only includes; Null, All & Electrophysiologist (EP).

             

            Don

            1 of 1 people found this helpful
            • 3. Re: Coloring for entire fields in a worksheet
              koushik.neelakantha

              Hello Don,

               

              Thanks for the reply. I need to get the Header name? is it possible.

               

              and I have almost 12 columns in my sheet. Can i apply the same logic using avg number of records?

               

              Regards,

              Koushik

              • 4. Re: Coloring for entire fields in a worksheet
                D Barnetson

                Hi Koushik,

                 

                Yes, you are able to show the headers. I hid them in my example.

                 

                To set up your headers so that they have the proper name you will have to right click on your top axis, click Edit Axis, change 'Title' to the name of you measure in that column, then, under the Tick Marks tab, select 'None': (select 'none' for both axis's)

                 

                Now your header will show:

                 

                I've used this method for reports with many columns, so 12 should be fine.

                 

                Hope this helps

                Don