1 Reply Latest reply on Mar 15, 2013 2:24 AM by Russell Christopher

    tableau - how to generate a dashboard in this format

    dora iyer
      App/date8/7/20128/8/20128/9/20128/10/2012
      Global1210233441000
      desktop15891
      pc36774323
      mac5345634679
      windows5567734666789

       

       

      • Global is a measure
      • Desktop,pc,mac and windows are from the app dimension.

       

      Row 1  is  the date

      Row 2 should show the values for that Measure (Global)

      Row 3  onwards should show the values for app dimension

       

      Attached please find the data extract and the workbook.

       

      any help will be highly appreciated !!!

        • 1. Re: tableau - how to generate a dashboard in this format
          Russell Christopher

          Dora - to get your date on Columns, just switch the DAY(Week Ending On) pill on Columns to "Exact Date" and then change it again to "Discrete"

           

          It sounds like you're essentially looking for a Grand Total across all Apps, but you want that number on top instead of on the bottom, where we normally place it - there may be some tricky ways to do this table calculations, but I personally would just something like a UNION in your Custom SQL...just create a second SELECT statement which generates a SUM() of this measure across rows, and name it "Global":

           

           

          SELECT 'Global' as App, SUM(Measure) as totalAcitve,....FROM Table

          UNION

          SELECT.....

           

          You'd then need to either do a manual sort to get this "new row" on top - or do something fun with an additional numeric column you add to your query to enable a more dynamic sort

           

          If you don't mind "Global" being the last row, then life is easy. Just turn Grand Totals on, then Format the label and change the Label property at the bottom of the Header tab to "Global" from it's original "Grand Total" text.

           

          Hope this helps a little - some of the other folks who work more on "formatting" may have better ideas, too.