9 Replies Latest reply on Mar 10, 2016 10:42 AM by Dan Hunnewell

    Adding Categories within my total fields

    Dan Hunnewell

      Hello,

       

      I have attached a sample Excel spreadsheet to show the data I am working with.

       

      I am doing the following with in Tableau to produce a bullet graph:

      1. day in columns
      2. Attendance actual and attendance plan in rows

       

      Next, I am looking to combine fields to produce categories which I would like to be within the "attendance actual" bars.

      1. Adult, child, senior in both General and TE will become "Tickets" category.
      2. Wednesday Grouping stays as is.

       

      I would then like to place these 2 groupings in the marks card under color to show the makeup of the actual attendance. How do I do this either within Tableau?

       

      Best,

      Dan