You can try this,
| makeresults
| eval value="1,3,5,0,4,5,6,0,1"
| makemv delim="," value
| mvexpand value
| fields - _time
| streamstats current=f window=1 last(value) as break
| append
[| makeresults
| eval value="1,3,5,0,4,5,6,0,1"
| makemv delim="," value
| mvexpand value
| fields - _time
| stats last(value) as final]
| fillnull value=0
| search value=0
| eval sum=break+final
| stats sum(sum) as sum
In your case, it will be
`your query`
| streamstats current=f window=1 last(value) as break
| append
[| `your query`
| stats last(value) as final]
| fillnull value=0
| search value=0
| eval sum=break+final
| stats sum(sum) as sum
... View more