I've got a challenge I can't seem to overcome. I would like to assign to every record the count of records of the same type between a change flag. It might be easier to visualize what I want to do from the attached spreadsheet.
The purpose is to be able to evaluate "overcoat %" by the length of time (# of coils) ran in succession of the same coating weight. From a basic standpoint, performance should improve (lower overcoat %) on longer runs of the same coating weight up to the bounds of process and measurement variation.
I thought the proper approach would be to:
1.) create a flag when the coating weight changes (done using Previous())
2.) then create a custom counter that counts the number of coils as long as the coating_change_flag is 0
3.) then figure out how to assign the last count of that to all the records of that group?
I'm totally stuck!
Thank you!!!
