Hi guys i am beginner. i need a help creating graphing none time series data in grafana using postgresql
Welcome @chylah11st
Please post your table schema? DDL and what kind of visualization do you want to try? bar chart?
okay
this is the data i have and i want to create gauge or barchart
this what i created so far
strong text
console_prod=# select * from report.vw_prod_act_by_status;
status | time
--------±-----
502 | 39
505 | 7611
513 | 6
0 | 7534
(4 rows)
schema=report
view=vw_prod_act_by_status
select * from report.vw_prod_act_by_status;
status | time
--------±-----
502 | 39
505 | 7611
513 | 6
0 | 7534
grafana
datasource=Console DB (app6)
1 Like
i don`t know much about grafana this is my first task
how did you do those guages
would you please send me the query you used to create the gauges
I used the query you posted. And notice for gauge I selected All Values Numeric as seen in this picture
so this is none time series data right
what do you see when you hover over that error icon?
No idea what that error is. I would either reinstall that plugin and/or restart grafana
okay thanks let me try that. i will let you know