I have sequence no of to populate . first column is the sequence of no and answers need to like in the second column
value value to populate
If increment is added for every NO ...
(your search)| streamstats sum(value) by no
View solution in original post
its not sum.
we need to have a sequence of no if value are same we need to mark it as 1 . if current sequence changes to other set of no. we need to increase the value by 1
|autoregress p=1 no as no_old
| streamstats sum(change) as inc_value
|table no inc_value