Count values only if they had changed (in compare to the previous row in table)
I have a problem with counting some of values - only if value in the previous row was different than in current one.
So for example from 01/06/2019 to 03/06/2019 it should be counted as 4 (4 times the value in customRManuf field has changed in this specific period). I was wondering if peek or previous function would be accurate in here?
Re: Count values only if they had changed (in compare to the previous row in table)
There would be differences in approaching the solution. If you want an additional column in the table with the count, you have to script differently (a join would be required), whereas, if you want in variable it is little different without join.