[BUG]Grafana 8.1+ compatibility

[taogejiang]

Dear @diafour , please check this problem, thanks very much .

• env: Grafana version: Grafana v8.3.3 flant-statusmap-panel version: 0.4.2 Data source type & version: MySQL OS Grafana is installed on: Centos v7.9 User OS & Browser: Windows 10 & Microsoft Edge

• problem:

"failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted" in grafana v8.3.3

but it's ok in grafana v7.4.0

• MySQL SQL: SELECT UNIX_TIMESTAMP(STR_TO_DATE(SUBSTR(trigger_time, 1, 8), '%Y%m%d')) AS time, concat(department,' - ',product_series,' - ',base_qgmr_version) AS metric, min(CASE ci_result WHEN 'FAIL' THEN 0 WHEN 'PASS' THEN 1 WHEN 'NONE' THEN 2 WHEN 'RUNNING' THEN 3 ELSE -1 END) AS "status" FROM qdevops_version_pipeline WHERE department='SW1' GROUP BY 1,2 ORDER BY metric

Looking forward to your reply ^-^

Originally posted by @taogejiang in https://github.com/flant/grafana-statusmap/issues/230#issuecomment-1033381014

[diafour]

Hello! It seems a bug in Grafana 8+: Grafana 8 failed to convert long to wide series when converting from dataframe

New release v0.5.0 supports DataFrames, please try it.