5 Replies Latest reply on Jul 26, 2018 4:25 PM by swaroop.gantela

    Waffle Chart for 3+ Items?

    Mya Starling

      Hi Everyone,

       

      I am looking to set up a waffle chart with three items (all I can find is 2-item waffle charts). I've searched on the forums and on the web and haven't found how to do this. Does anyone know if this is possible?

      Thank you in advance.

        • 1. Re: Waffle Chart for 3+ Items?
          swaroop.gantela

          Mya,

           

          Would be grateful for clarification of 3 items:

           

          are you seeking 3+ dimensions on one waffle

          Tableau Public

           

          or 3+ separate waffles?

          Tableau Public

          • 2. Re: Waffle Chart for 3+ Items?
            Mya Starling

            3 items in one waffle, to replace a pie like this:

            orders.png

            • 3. Re: Waffle Chart for 3+ Items?
              swaroop.gantela

              Mya,

               

              This example may be similar to yours:

              Tableau Public

               

              276618waffle1.png

               

              276618waffle2.png

               

              Please see workbook of the above v10.2

              attached in the forum tread.

              1 of 1 people found this helpful
              • 4. Re: Waffle Chart for 3+ Items?
                Mya Starling

                Yes! This is exactly what I'm trying to do! I looked at the tableau file and still cant figure out how to add the third element. it does a walkthrough of the two element charts but that's it... the Sales by Regipn sheet has the 3 element waffle but I cant figure out whats going on w/o the data and it won't let me access the data source page (says the source is missing). Do you know if there is a way to message people in tableau public to get more information?

                • 5. Re: Waffle Chart for 3+ Items?
                  swaroop.gantela

                  Mya,

                   

                  I was able to get to the underlying table and recreate the workbook.

                   

                  Though we're not able to get to the datasource, you can see

                  what it was made of by clicking on "View Data" icon:

                  276618waffleData.png

                   

                  The file is a scaffold, and its just the sequence of Column numbers and Row numbers:

                  1|1, 1|2, ...1|10, 2|1, 2|2 ..., 10|10

                  This file is attached.

                   

                  I think you've seen the posts describing how the data is being blended to the scaffold

                  even though there isn't a common key between them. Here, I will do my best to just

                  describe the steps that I took to get it to work.

                   

                  The Regional Sales calculations are on the Data side and are straight from Ben's workbook:

                  SUM(IF [Region] = "Central" THEN [Sales] END)/SUM([Sales])

                  etc.

                   

                  The Scaffold side has the calculation [Region Percentage]:

                  IF INDEX() <= [Sample - Superstore].[Sales South]*100 THEN "South"

                  ELSEIF INDEX() <= ([Sample - Superstore].[Sales South]+[Sample - Superstore].[Sales Central])*100 THEN "Central"

                  ELSEIF INDEX() <= ([Sample - Superstore].[Sales South]+[Sample - Superstore].[Sales Central]+[Sample - Superstore].[Sales East])*100 THEN "East"

                  ELSE "West" END

                   

                  which is checking if the percentage is greater than or equal to the individual block's index,

                  and is offset by the percentage of the regions that came before.

                  It has very specific table calculation settings:

                  276618waffleCalc.png

                   

                  There is one other field on the Detail shelf which is the created by control-clicking on the both Columns and Rows

                  and the right-clicking > create > Combined Field which gives every combination of column and row.

                   

                  It looks like the labels were done by Annotations.