579519_en-US

liliconcom

How to assign and increment an iteration count for multiple variables with unequal rows?

Hello all.

Im trying to create a column which assigns an iteration number (numeric and continuous) based on column "Comment = End of Cycle" and increments it for the same SN. The number of data points for each SN is not the same. 

For example.

for SN = "A", rows 1-9: Iteration =1, rows 10-16 Iteration =2

for SN = "B", rows 17-27: Iteration =1, rows 28-36 Iteration =2 and so on...

 

Tried a few variations using the  Row ( ) function but was not successful. Can someone provide some guidance on this?

 

 

 

 

 

AnalyticsData Table