Greetings,
I have the following index populated each 3 minutes:
{
  "template": "web-*",
  "settings": {
    "number_of_shards": 1
  },
  "mappings": {
      "web-": {
      "_source": {
      "enabled": true
      },
      "properties": {
        "@timestamp": {
          "type": "date",
          "format" : "epoch_second"
        },
        "uri": {
          "type": "keyword"
        },
        "http_status": {
          "type": "integer"
        },
        "downtime": {
          "type": "integer"
        }
      }
    }
  }
}
Now the variable "downtime" will be equal to 3 (minutes) if "http_status" is different than 200.
I want to calculate based on "time" and "downtime" the availability percentage of my web each month for example:
"total downtime for this month" = 200 min --> how can I get this value each month?
"time in minutes of this month" = 44640 min
availability percentage by month = (200 / 44640 ) * 100
Now how can I get the availability percentage automatically calculated and want to report it by the end of each month?