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?
What is your data source (ms sql, mysql, postsgres) and which visualization are you planning on using?
Please post some sample data?
SELECT Concat(CAST(time as date), ' Hour: ', DATEPART(hour,time)) AS metric,
COUNT(*) AS Totals
GROUP BY CAST(time as date),
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
I would now like to have bar charts, e.g. for growth per day, week etc
What I don’t understand is you have plugin zabbix but what is the data source? mysql?