grafana / grafana-zabbix

Zabbix plugin for Grafana dashboard
http://play.grafana-zabbix.org
Apache License 2.0
2.08k stars 458 forks source link

Get Min/Max over a time period for cumulated data #1522

Open docholiday opened 2 years ago

docholiday commented 2 years ago

Describe the bug Hi, I try to show the average, minimum and maximum incoming and outgoing traffic for a website over 6 months. Therefore I made a panel (Time series) with a query to Zabbix for all webservers belonging to the site. It takes the incoming traffic for every webserver. And then on the transform tab, I use "Reduce row" mode and Calculation "Total" and replace all fields.

So far that LOOKS good. BUT it seems to take way to few datapoints, as e.g. the Max value is now only 59Mb/s (for all servers) instead of a Max value of 133 Mb/s already for the first server according to Zabbix (within the same time span). If i change the "Max data points" under "Query options" to 10,000 I get a Max value of 64 Mb/s, but that seems to be the 'best' I can get. Even 400,000 data points don't change that value anymore.

So I thought I use this graph only for the average and then try to find another way to just show Max and Min values as stats in new panels. But so far, I haven't found a way to do that. If I use trendValue(max) (as mentioned here: https://github.com/alexanderzobnin/grafana-zabbix/issues/1052), I get a much too high value as the absolute max values of every included webserver seem to be summed up, no matter at which time they occurred. Any help would be highly appreciated!

Expected behavior Get the correct (or at least better) min and max values for all servers together over time.

Screenshots Zabbix Webtraffic Grafana Webtraffic

Network data Grafana Webtraffic.zip

Software versions

Grafana Zabbix Grafana-Zabbix Plugin
9.2.1 5.0.22 4.2.10

Regards, Docho

github-actions[bot] commented 6 days ago

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!