Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |