Row functions are essential in manufacturing data.
- We use Dif() to calculate the rate of change (slopes, or derivatives), which can be correlated to our target of interest.
- Lag() is also used to align data (upstream and downstream equipment)
However, when having tables with a column indicating different groups, new users are out of luck.
Two consecutive rows can belong to different groups and the only way to guarantee this is by adding complex formulas with conditionals (example).
It will be much easier for the user to include a <byVar> argument in Dif() and Lag().
For example, Col Cumulative Sum() is another row function that does allow this!
Here, I am creating a simple counter where I don't need to be worried about conditionals.
2 Comments