How do I rank rows based on date if I have Date field values repeating twice?

[akawacz]

Hi

Could you help me with Ranking rows? I was trying to use streamstats, but the issue here is that I have a Date repeated twice.

My data

Date         type   count
2015-08-01    A     2000
2015-08-01    B     1000
2015-07-01    A     2000
2015-07-01    B     2000

Expected result

Date         type   count  Rank_filed
2015-08-01    A     2000        1
2015-08-01    B     1000        1
2015-07-01    A     2000        2
2015-07-01    B     2000        2

Thank you

[somesoni2 · Accepted solution]

Try this

your current search giving first output | streamstats current=f window=1 values(Date) as prev | eval Rank_filled=if(prev=Date,0,1) | accum Rank_filled