Singlestat Panel doesn't refresh

Grafana Stat Panel
1

Hi,

i cannot achieve to have a Singlestat Panel with real-time data refresh.
I use postgresql as data source.
I have written a simple query that extract 1 text value and it’s correctly displayed on my panel but when I change thet value on db the panel doesn’t refresh automatically as i expected.

I know there’s something i’m missing, but what?

2

Hi,

Singlestat panel only works with numeric values that can be mapped to string values. Please include your query here for further support.

Thanks

Marcus

3

Hi mefraimsson,

i have a simple singlstat panel with a gauge that display this metric:

SELECT
oee
FROM
iot40.“Counters”

from a postgres database.
I like to see the value changing on the dashboard when i change it on db.
Is it possible?

4

You want to use a time-series query as explained in documentation.

Something similar to

SELECT 
 $__timeSec(now()),
  oee as value
FROM
iot40.“Counters”
LIMIT 1

But if oee column is a string I don’t think it will work, but give it a try.

Marcus

5

The value in gauge is correctly showen but the value is not updated :confused:

6

What is the value displayed?

If you have some column (date or primary key) that you can use to order the result by I would suggest that, i.e. ORDER BY <column>.

Marcus

7

My table i so simple, it has this structure:

oee,total_producted,last_run,availability,total_ok,quality_sum,total_cycles,quality,total_faults,performance,total_count
0.9292735496852251,1178057,63,0.9900136909076266,12355,12284.837987103772,12417,0.9893563652334519,62,0.9487452685833937,1241700

i’m thinking i miss something in working model…

8

Ok i solved :smiley:

9

Cool. I answered with that query 3 days ago :slight_smile:

10

Yes,

but i’am too stupid to change the time picker, sorry for wasting your time mefraimsson and thank you again :slight_smile:

11

No worries. Glad you sorted it out.