Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouping specific rows together

I have a data set of production values from various machines that I'm using to calculate machine utilization. I used group by to combine the values into machine and date and sum the run hours. Below shows the data. The rows are machine, date, mfg cell, mfg type, run hours, and scheduled hours.

 

I want to combine 0556-LEGO 2-1 and 2-2 into one value (0556). Is there any way to group these into one column so they don't show up as duplicates in my sums without having to filter one out?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous 

    I see. Does this possibly work? I added Column 2, 3, 4, and 6 to the GROUP BY function in order to return them.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

    Before using Group By, you could try to just replace both variable names with "0556." In "Edit Queries," you can:

    1. Select the entirety of that first column

    2. Right click, find "Replace Values..."

    3. Replace "0556-LEGO 2-1" and "0556-LEGO 2-2" with "0556"

    4. THEN use Group By to group the values of "0556" together

    Does that work?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks! The problem with that is that when I group them, I sum the run hours so if a press makes two different parts in a day, it'll say it ran for the sum of those two parts.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous 

        I see. So you just want an average then?