# None Time Series with postgres **URL:** \ **Category:** Grafana\ **Tags:** templating\ **Created:** [October 26, 2023, 3:26pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462 "2023-10-26T15:26:47Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 3:26pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/1 "2023-10-26T15:26:47Z")
Hi guys i am beginner. i need a help creating graphing none time series data in grafana using postgresql ---
**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\ **Post date:** [October 26, 2023, 3:33pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/2 "2023-10-26T15:33:42Z")
Welcome @chylah11st Please post your table schema? DDL and what kind of visualization do you want to try? bar chart? ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 3:42pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/3 "2023-10-26T15:42:53Z")
okay this is the data i have and i want to create gauge or barchart this what i created so far ![Screenshot (3)](https://us1.discourse-cdn.com/grafana/original/3X/6/b/6b35794f73100074057d7cb765ba37f7441d2652.png) > [@yosiasz](#): > > Welcome @chylah11st > > Please post your table schema? DDL and what kind of visualization do you want to try? bar chart? **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) ---
**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\ **Post date:** [October 26, 2023, 3:46pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/4 "2023-10-26T15:46:17Z")
What is this time value that show numeric value? ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/8/c8ebdbda01c4a6a9c3f3ec8f9f7616e6cc2bd4d0.png) ![image](https://us1.discourse-cdn.com/grafana/original/3X/e/e/ee38c854f703fff6c8c6c3b27c5f89ae4a2f5313.png) ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 3:50pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/5 "2023-10-26T15:50:51Z")
i don`t know much about grafana this is my first task ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 3:52pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/6 "2023-10-26T15:52:53Z")
how did you do those guages would you please send me the query you used to create the gauges ---
**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\ **Post date:** [October 26, 2023, 3:56pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/7 "2023-10-26T15:56:29Z")
> [@chylah11st](#): > > 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 ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/b/4ba40c1d3653917a9246720c62404d0200fd6a2d.png) ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 4:11pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/8 "2023-10-26T16:11:48Z")
okay Im getting an error here ![Screenshot (6)](https://us1.discourse-cdn.com/grafana/original/3X/5/d/5d8bd1a7f80574d641e50dc3bd8479a5b0b87e3a.png) ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 4:12pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/9 "2023-10-26T16:12:26Z")
so this is none time series data right ---
**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\ **Post date:** [October 26, 2023, 4:33pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/10 "2023-10-26T16:33:15Z")
what do you see when you hover over that error icon? ![image](https://us1.discourse-cdn.com/grafana/original/3X/6/3/63953bf4c86197f542e278e7dab047671e062fb0.png) ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 26, 2023, 11:31pm UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/11 "2023-10-26T23:31:52Z")
![Screenshot (7)](https://us1.discourse-cdn.com/grafana/original/3X/f/7/f76317c1dd798572d774f3fe014b513e5cfad2fe.png) ---
**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\ **Post date:** [October 27, 2023, 12:10am UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/12 "2023-10-27T00:10:12Z")
No idea what that error is. I would either reinstall that plugin and/or restart grafana ---
**Author:** ![chylah11st](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@chylah11st](https://community.grafana.com/u/chylah11st)\ **Post date:** [October 27, 2023, 12:21am UTC](https://community.grafana.com/t/none-time-series-with-postgres/106462/13 "2023-10-27T00:21:53Z")
okay thanks let me try that. i will let you know