I have sequence no of to populate . first column is the sequence of no and answers need to like in the second column
for Example
value value to populate
10 1
10 1
10 1
15 2
15 2
10 3
If increment is added for every NO ...
(your search)| streamstats sum(value) by no
If increment is added for every NO ...
(your search)| streamstats sum(value) by no
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
How's this?
(your search)
|autoregress p=1 no as no_old
|eval change=if(no=no_old,0,1)
| streamstats sum(change) as inc_value
|table no inc_value