Configuring time series dashboard

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?
    Grafana v9.1.4
  • What are you trying to achieve?
    Monitor the message queue of my application
  • How are you trying to achieve it?
    Selecting a count(*) of my message queue table
  • What happened?
    The count value is not shown in the graph.

Hello dear community,

i recently started to use Grafana and i just can’t seem to wrap my mind around this.
My application uses the com_received_message table as a message queue. I want to monitor the count of this table. I want to be able to see how many messaged were in the message queue at one point in time.

What am i doing wrong? Can someone please push me in the right direction? Thank you in advance!

2

Welcome

what data type is dati_processed? Also can you try adding

$time(dati_processed) as time
4

Click on the Show Help next to time series and you will see all of the time related functions.

5

I already did but i can’t figure out what I’m doing wrong.

6

When clicking Show Help look at Macros: and compare what you have with the list of time related functions.

image
image1044×257 41.7 KB

7

I am using $__time just as it’s described there, but it doesn’t show up for some reason

8

time for some coffee
image

10

oops sorry, $__time for some coffee for me!

$__time(dati_processed) as time

or

SELECT
$__timeGroup(dati_processed,'1d', NULL) time,
count(1) as value
FROM com_received_message
GROUP by $__timeGroup(dati_processed, '1d')

image
image556×725 35.1 KB

12

probably means your dati_message is not utc but local time

image

image