Hi,
I have somewhat of a challenge I can't quite figure out.
I have an SQL table full of production data information and some OK counters.
The OK counters are not normalized, meaning they carry on the counter from the previous order.
I would like to add a column to my dataset, where I normalize this data.
How I imagined I would do it, was simply to subtract the MIN value, for that production line.
Unfortunately I can't figure out how to select a subset of the rows, based on the production line's Id.
If I just do a min(), I will select across multiple production-lines, meaning the min will only be valid for one of them.
So my table is basically:
ProductionLineId, OrderNo, Timestamp, OkCounter
Where I'd like to add a NormalizedOk.
How should I go ahead with achieving this?
I hope it is clear what I'm trying to achieve. Please ask any questions that come up.
This is how I would try to solve the problem,
Min/Production ID = Summarize(<YourTableName>, ProductionID, min (OK number))
This will generate a table that conatins the minimum for each production id. Then you can join this table with the original and create a new calculated column where you subtract i.e
Normalized number = ok number - min number
Let me know if this helps
User | Count |
---|---|
97 | |
39 | |
36 | |
16 | |
14 |
User | Count |
---|---|
99 | |
30 | |
29 | |
16 | |
16 |