incremental value

[DataOrg]

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

[HiroshiSatoh · Accepted solution]

If increment is added for every NO ...

(your search)| streamstats sum(value)  by no

[DataOrg]

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

[HiroshiSatoh]

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