Hi rmercy,
using your provided information, I created a CSV containing this:
host,count,day
A,1028,1
A,112,2
A,4765,3
A,257,4
A,1046,5
B,1028,1
B,112,2
B,4765,3
B,257,4
B,1046,5
C,1028,1
C,112,2
C,4765,3
C,257,4
C,866,5
D,1028,1
D,112,2
D,4765,3
D,257,4
D,866,5
E,1027,1
E,112,2
E,4765,3
E,257,4
E,866,5
F,1027,1
F,112,2
F,4765,3
F,257,4
F,866,5
based on this CSV I was able to use this search and get the delta of each of the count files:
base search to search for the above file sourcetype="csv"
| stats values(count) AS count by day extracted_host
| streamstats current=f last(count) as previouscount by day
| eval delta=previouscount-count
| chart values(count) AS count values(delta) AS delta over extracted_host by day
The result will look like this:
Adopt the search to your needs.
Hope this helps ...
cheers, MuS
... View more