Wrong calculation of sla values when multiple hosts selected

[FROGGS]

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

1. Make sure you have one or more hosts down in a certain timeframe.
2. Create a report for all hosts by e.g. filtering for host_name=*.
3. Create another report with same options, but filter for one specific host.
4. 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]

ref/NC/706206

[pdolinic]

ref/NC/749709

[lippserd]

Hi @FROGGS,

Are you still having this issue?

All the best, Eric

[FROGGS]

Hi, we've updated to the latest versions just recently, the error seems to be gone.