How to visualising availability metric in histogram

We are trying to visualise an availability value in Kibana but haven't been able to so for when there are multiple values for the same period.

We have a service, i.e. telephony, we measure how many users are using the service (e.g. 1000). We measure when the service has an outage (faulty device) and home many users were impacted by this outage (250 users) for the period (300 minutes). Now at the end of the month (30 days) we want to know how the outage has impacted the service has a whole. No outages means 100% availability. With the 1 example outage above we calculate (250 users x 300 mins) / (1000 total users x 30 days) = 0.1736% of availability impact which means the service was available for 100% - 0.1736% = 99.8264%

We can calculate the availability impact for each event in logstash but how would we aggregate this when there are more than one events in a period (month, quarter or year)

Has anyone had any experience with this?

any suggestions welcome.

Hey Aleks,

You might want to use formulas in the Lens visualization builder. Create visualizations with Lens | Kibana Guide [8.4] | Elastic

I hope this helps,