if i put this search query, i get the correct total no output, but with "zero" blocked output.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
sourcetype="pihole:log" tag=dns tag=network tag=resolution message_type="Query"
|stats count as total, count(eval(query_type="Blocked")) as blocked
|eval percent=round((blocked/total)* 100,1)
total blocked percent
20433 0 0.0
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
And below results shows the correct no. of blocked outputs, but too many entries outputs
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
sourcetype="pihole:log" tag=dns tag=network tag=resolution
|stats count as total, count(eval(query_type="Blocked")) as blocked
|eval percent=round((blocked/total)* 100,1)
total blocked percent
91921 3683 4.0
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
... View more