5 Replies Latest reply on Sep 24, 2018 6:57 PM by Vincent Baumel

    Still baffled by the Tableau Prep Aggregate step

    Vincent Baumel

      Hi friends-

       

      I'm running into a problem with a join. Looking at the resulting granularity of my data it's something akin to this:

       

      Start_TimeEnd_TimeNameDepartmentActivity_CodeMeasurement

      Reason_Code

      9/1/2018 12:08:39 AM9/1/2018 03:15:24 PMVince400408150.113333
      9/1/2018 12:08:39 AM9/1/2018 03:15:24 PMVince400408150.08753
      9/1/2018 12:08:39 AM9/1/2018 03:15:24 PMVince400408150.249173
      9/1/2018 12:08:39 AM9/1/2018 03:15:24 PMVince400408153.912223

       

       

      I've got multiple rows in which the only difference is the Measurement field. What I'd *like* to do is roll those up so that each row has only one Start_Time. Since Tableau Prep materializes things like LOD calculations, I know my solution probably involves the Aggregate step. I've watched the training videos and everything, but I'm still just a bit confused about how to make this work. I feel like the answer is simple, I just can't wrap my head around it. Can someone explain this to me?

       

       

       

      -Vince