Ping integration data when there is no connection


I am using the ping integration (Ping (ICMP) - Home Assistant) to check if HA has an active internet connection using the following code:

  - platform: ping
    name: "Ping_google"
    scan_interval: 60

The integration works and shows when there is a connection and when not. But when I look at the data I see there is a 1 in the database every 60 seconds. But when there is no connection there is only a single 0 (not every 60 seconds), see image below. Is there a way to have a 0 every 60 seconds? In this way I can calculate the uptime of the connection.