Wrong calculation of sla values when multiple hosts selected

FROGGS commented 3 years ago

Describe the bug

We had a downtime for a bunch of hosts last month. But when I look at our host sla report these are displayed as 100% available. So I picked a hosts where I know it was down, and made another host sla report for that specific host. Now this report shows that the host was available for about 96.9% of the time. Both reports only differ in the filter settings as shown below.

To Reproduce

Make sure you have one or more hosts down in a certain timeframe.
Create a report for all hosts by e.g. filtering for host_name=*.
Create another report with same options, but filter for one specific host.
Compare the sla value for the same host in both reports.

Expected behavior

Both reports show the same values for a host in a certain timeframe.

Screenshots

Report for multiple hosts:

Report for single hosts:

Your Environment

Module version:
Dependent module versions:
Icinga Web 2 version and modules (System - About):

Thing	version
Icinga Web 2	2.8.2 commit 8a89839af94a247ee2149b2336c73b8251b477c0
businessprocess	2.2.0
director	1.7.2
doc	2.8.2
grafana	1.3.6
idoreports	0.9.1
incubator	0.5.0
ipl	v0.5.0
monitoring	2.8.2
pdfexport	0.9.1
reactbundle	0.8.0
reporting	0.10.0
statusmap	0.0.0

Web browser and version: Chrome Version 89.0.4389.114 on Windows 10
Icinga 2 version used (icinga2 --version): r2.12.1-1
MySQL version (mysql --version): mysql Ver 8.0.22-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))
PHP version used (php --version): PHP 7.4.3 (cli) (built: Oct 6 2020 15:47:56) ( NTS )
Server operating system and version: Ubuntu 20.04.2 LTS (GNU/Linux 5.4.0-66-generic x86_64)

Wintermute2k6 commented 3 years ago

ref/NC/706206

FROGGS commented 3 years ago

I've moved this issue to the reporting repo, as requested: Icinga/icingaweb2-module-idoreports#61

Icinga / icingaweb2-module-idoreports