1 Reply Latest reply on Jun 13, 2016 1:11 PM by Joshua Milligan

    Create blue pills from extract file

    Suresh Kumar Pondicherry

      Hi All,

      Am new to tableau. Am trying to create a blue pills from the extract file. Have attached the expected.png and work sheet. Please help.

       

      Kind regards,

      Suresh

        • 1. Re: Create blue pills from extract file
          Joshua Milligan

          Suresh,

           

          This can happen when your data is shaped in such a way that you have multiple fields that represent a single measure.

           

          In this case, you have a separate measure for each Ward, when you really want to have a single measure (rate) per Ward (which should be a dimension).

           

          There are a couple of alternatives:

          1. use Measure Names / Measure Values.  If you put Measure Names on Rows and Measure Values on Columns, you'll have a chart similar to your desired.  You can copy Measure Values to Rows and then use the drop down menu on the field to switch it to discrete.

           

          2. Reshape your data from

           

           

          MonthWard 1Ward 2Ward 3
          Jan0.50.10.2
          Feb0.40.50.5
          Mar0.30.30.3
          Apr0.30.20.2
          May0.50.30.3

          (this is "wide" data - many columns for a single measure)

           

          to

           

           

          MonthWardRate
          Jan10.5
          Jan20.1
          Jan30.2
          Feb10.4
          Feb20.5
          Feb30.5
          .........

          (this is "tall" data - many rows with one dimension and one measure for all the columns above)

           

           

          You'll find the "tall" data much easier to work with in Tableau.

           

          Best Regards,

          Joshua