I want to calculate a difference between count columns and want to project the growth in the number of messages each mon

[dhruvin24]

Here's my query and I want to calculate the difference between count (_raw) each month . It would be a running column so next month it would include the August month and then September and so on.. Can anyone please provide me solution to it ?

[dhruvin24]

Thanks for the help.

[ITWhisperer]

| stats count as current by date_month
| streamstats values(current) as previous window=1 current=f
| eval diff=current-previous