Hi,
I am using streamstats to calculate the rank based on cumulative count per day per category. On few days, a particular category may not appear. So, on those days, I want to have the count for that category from the previous day. I tried all the arguments of streamstats and other commands with no success. Can someone help me on it please?
I am pasting the code of similar case but for ranking based on the cumulative points for each football match
index=index
| stats sum(TotalPoints) AS Points BY match, "Sold To"
| fillnull value=0
| rename "Sold To" AS Owner
| sort match
| streamstats sum(Points) AS Total BY Owner
| sort match Total
| streamstats count AS Rank BY match
| xyseries match Owner Rank
Output
match
Owner1
Owner2
Owner3
1
2 (Rank 2, Total: 10)
1 (Rank 1, Total: 15)
(Total: 0)
2
1 (Rank 1, Total: 25)
3 (Rank 3, Total: 18)
2 (Rank 2, Total: 20)
3
(Total: 0)
2 (Rank 2, Total: 23)
1 (Rank 1, Total: 30)
Expected Output
match
Owner1
Owner2
Owner3
1
2 (Rank 2, Total: 10)
1 (Rank 1, Total: 15)
3 (Rank 3, Total: 0)
2
1 (Rank 1, Total: 25)
3 (Rank 3, Total: 18)
2 (Rank 2, Total: 20)
3
2 (Rank 3, Total: 25)
3 (Rank 2, Total: 23)
1 (Rank 1, Total: 30)
... View more