I have used the below query to get the total from that column
Index="" source=""
| fields queryHits | table queryHits | addcoltotals labelfield=total label="queryHits"...
Now how do i get only the last row which is the total to display in my dashboard.I tried using stats count but its not fetching the correct vaue
You could just take the last line using tail
index="" source=""
| fields queryHits
| table queryHits
| addcoltotals labelfield=total label="queryHits"
| tail 1
but there's a better way to get just the total
Index="" source=""
| stats sum(queryHits) as queryHits
thank you