Could someone help in creating a Grafana dashboard which shows the historical availability/uptime of a pod?

What Grafana version and what operating system are you using?
Grafana v11.4.0

What are you trying to achieve?

Could someone help in creating a Grafana dashboard which shows the historical availability/uptime of a pod?

ie how can I see last 6 months graph to understand which day/time a pod went down?

How are you trying to achieve it?

I am trying to visualize this through a Grafana dashboard

What happened?

Tried using the below query, but this is not providing the accurate information

deriv(kube_pod_status_phase{namespace=“$namespace”}[5m])

What did you expect to happen?

At the end, I should be able to see last ‘n’ months graph to understand which day/time a pod went down.