I am trying to show column data as a series name and column data again as values.
Can you help me how can i achieve that ? Below is the data i want show as a series and values.
127.0.0.1/grafana/grafana/ http://localhost/phpmyadmin/tbl_sql.php?db=grafana&table=grafana
Showing rows 0 - 9 (10 total, Query took 0.0104 seconds.) [time: 26235… - 4582…]
SELECT coupanqty as ‘time’, concat("Coupan Number ", coupannumber) as ‘metric’ FROM grafana GROUP BY coupannumber ORDER By time DESC LIMIT 10
time metric
26235 Coupan Number 9914650115001
9886 Coupan Number 9914650041508
7978 Coupan Number 9914650052009
6736 Coupan Number 9914650062503
6384 Coupan Number 9927876172000
5677 Coupan Number 9914650073004
5621 Coupan Number 9900263061804
5392 Coupan Number 9903039944004
4863 Coupan Number 9914650083508
4582 Coupan Number 9906592023100
Thanks & Regards
Ishtiaq Shariff