Represent growth

[pcnico]

Hello,

I’ve just started with Grafana and I can’t find the right function for my task…

Simple example: I record the number of emails in the inbox every 1min.
In the database there is an absolute number that increases.

Now I want to do evaluations with Grafana…

How many new mails per hour or per day
The absolute values of the beginning and end of the set period must therefore be subtracted from each other…
The whole thing should then be displayed as a bar chart.

Which function can help me with this?

Thanks

[yosiasz]

Welcome

What is your data source (ms sql, mysql, postsgres) and which visualization are you planning on using?
Please post some sample data?

time,emailcount
2022-07-21 09:34:20.993,1
2022-07-21 09:35:20.993,22
2022-07-21 09:36:20.993,13
2022-07-21 09:37:20.993,44
2022-07-21 09:38:20.993,5
2022-07-21 09:39:20.993,0
2022-07-21 09:40:20.993,11

--MSSQL server
SELECT Concat(CAST(time as date), ' Hour: ', DATEPART(hour,time)) AS metric,
       COUNT(*) AS Totals
FROM emails
GROUP BY CAST(time as date),
       DATEPART(hour,time)

[pcnico]

The data comes from Zabbix. I have already set up the plugin. So the data manipulation has to happen in Grafana…

The numerical values are constantly increasing

2022-07-22 10:00 5000
2022-07-22 10:05 5070
2022-07-22 10:10 5080
Etc

I would now like to have bar charts, e.g. for growth per day, week etc

[yosiasz]

What I don’t understand is you have plugin zabbix but what is the data source? mysql?