I have upgraded my Grafana from version 7.0.3 to 8.0.3 and now all my Graph panels have been distorted. First, it has been renamed to graph(old) and now my query is not sorting data by date which earlier was working fine.
The same query has been working fine in PostgreSQL editor or PGAdmin but not working in graph panel.
select now() as time, sum(“high_vulnerabilities”) AS " ", “scan_date” from “checkmarx_pg” where “project” in ($Project1)
group by scan_date ORDER BY to_date(“scan_date”,‘DD-Mon’) ASC