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
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
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