public function Overall_byDepartment()
    {
        $sQuery  = "EXEC  [dbo].[WebReport_Overall_byDepartment]" ;

        $aRawResults = DB::connection($this->connection)->select($sQuery);

         return $aRawResults;

    }

public function index(Request $request) {

        $aData= $this->oChartManager->Overall_byDepartment();
        $this->aData['sReportName'] = 'dashboard';
        $this->oChartManager->setReportName('dashboard');
        $this->aData['aData']= $aData ;

        $result[] = ['department_name','oascore','level0_score' ];
        foreach ($aData as $value)  {
            $value = [(string)$value->department_name,
                    (float)$value->oascore,
                    (float)$value->level0_score,
            ];

            array_push($result, $value);
                                    }

        return view('reports.template')
        ->with('aData',json_encode($result));
    }