Forum Discussion
Grouping specific rows together
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.
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?
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
I see. So you just want an average then?
Yeah an average would work for that press if it can be done separately from grouping the others.