Unable to see Ping result_code

Hi there, I hope this is the right place to post this.

I have been learning Grafana and Telegraf. I would like a dashboar that tracks internal servers and everything is working well. I am using this dashboard here (https://grafana.com/dashboards/2690).

So i would like the pings on the Ping Metrics tab to show 0 and go red once its failing a ping (computer is off). However i can’t seem to work out the query to use to show me its actually off. At the moment it is showing me (what i think is an average). I have tried to use the result_code field within ping but i can’t work out how to just show me the exact value within the database.

Any advice would be great!

Thanks.