Hi, for such scenarios there is BI:
https://docs.checkmk.com/latest/en/bi.html?lquery=business#_an_example
Karl