2 Replies Latest reply on Sep 12, 2013 6:38 AM by Matthew McLaughlin

    Total of actual run hours for an entire work order:  Grouping?

    Matthew McLaughlin

      Got one regarding totals of standard and actual hours (to report variances).  The requirement was to report per work order.

       

      This is what my data looks like:

       

      Order NoOperationStandard HoursActual Hours
      120000501.01.1
      12000100.5.41
      12000200.851.2
      120003001.31.1
      123500501.0.9
      12350100.5.38
      12350200.85

      1.

      123503001.31.1

       

       

      So basically, I need to total the standard and actual hours for each unique order.  If this was Excel, I could make some groups and subgroups.  In tableau, however, my Group icon is disabled!  I take this to mean I need to create a calculation field....after that, I'm a total blank.

       

      Any suggestions are greatly appreciated!

       

      Matt