Forum Discussion
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 ...
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.
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.
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.
I think that'll do it! Thanks