Unable to output get the _value for single stat "deadman" alert

Using influxdb Cloud v2, I have set up a Deadman alert successfully and I get the slack message.
However, I would like to have the deadman status (true or false) on my board.
When I try to do the query and output it in a single stat widget, it always show the _check_id instead.

Anyone has a clue?

from(bucket: "_monitoring")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => 
    r["_measurement"] == "statuses"
    and r["_check_id"] == "083f4bddba1ad000"
    and r["_check_name"] == "test bench"
    and r["_field"] == "dead")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "last")