Query

        $MMV = TableRegistry::get('Monthlyvalues');
        $query = $MMV->find()->contain(['Facilities']);
        $result = $query->select(['sum_vegi' => $query->func()->sum('Monthlyvalues.vegi_val'),
            'sum_mos' => $query->func()->sum('Monthlyvalues.mos_val'),
            'sum_ges' => $query->func()->sum('Monthlyvalues.nor_val'),
            'Facilities.colorcode', 'Facilities.tour_id', 'Facilities.facility_type'
        ])
            ->where(['Monthlyvalues.year' => $year, 'Monthlyvalues.month' => $month,
                'Monthlyvalues.day' => $day, 'Monthlyvalues.is_visible' => 'X', 'Facilities.tour_id IS NOT' => null])
            ->group(['Facilities.facility_type', 'Facilities.colorcode'])->toArray();