I get error

Message: Non-static method koolreport\dashboard\sources\PDOSource::raw() should not be called statically 

When trying to use a raw query in the dashboard I'm receiving this error when trying to query a MSSQL database

This is how I'm using it

CircSrc::Raw("Select * FROM vt_TotalCircsbyMonth
        PIVOT
            (SUM(TotalCircs)
            FOR YearNum IN ([2021], [2020], [2019], [2018])
            )AS pvt ORDER BY month(NameofMonth  + ' 1 2014')");

When I change it to this

(new CircSrc)->Raw("Select * FROM vt_TotalCircsbyMonth
        PIVOT
            (SUM(TotalCircs)
            FOR YearNum IN ([2021], [2020], [2019], [2018])
            )AS pvt ORDER BY month(NameofMonth  + ' 1 2014')");

I get an error about not having a table.

Can you explain how using the dashboard I can run a run a raw query

Perfect...Thanks