Create Grafana Dashboard by querying InfluxDB 2 using Flux
Budget: €30 – €100 EUR
Hi,
because I am in hurry:
Create a Grafana dashboard to show the attached data (stored in InfluxDB 2.X using Flux as Query language).
The fields c1xx, c2xx, c3xx, c401, c403, c404, c4xx, c5xx contains integers. A stacked bar chart for these fields is the first idea, but it is a bad one! Do you have a better one? E.g. lines which are 'stacked'?
Something like https://play.grafana.org/d/000000012/grafana-play-home?orgId=1&from=1640977308207&to=1640977766282&viewPanel=2
But: Is it possible to see all values at a timestamp at once instead of only the one you are over with the mouse?
And is it then also possible to see the sum of all values? Like 'Sum: nnnn'
Note that c2xx and c3xx have 'big' values while the others are small (mostly 0, kinda rare between 10-50).
So maybe both values should be at the bottom?!
first_byte_in_ms_mean_value is in milliseconds while bytes_received and bytes_sent are bytes.
Is it possible to have all values in just one graph? Or does it looks too bad? Else use two.
There should be a nice legend. The default one is bad, because it it clear that we only have values for one host!
So it should be something like '<yellow>: Codes for success (c2xx)'
Yes, if the DB schema is bad for this we can change it!
because I am in hurry:
Create a Grafana dashboard to show the attached data (stored in InfluxDB 2.X using Flux as Query language).
The fields c1xx, c2xx, c3xx, c401, c403, c404, c4xx, c5xx contains integers. A stacked bar chart for these fields is the first idea, but it is a bad one! Do you have a better one? E.g. lines which are 'stacked'?
Something like https://play.grafana.org/d/000000012/grafana-play-home?orgId=1&from=1640977308207&to=1640977766282&viewPanel=2
But: Is it possible to see all values at a timestamp at once instead of only the one you are over with the mouse?
And is it then also possible to see the sum of all values? Like 'Sum: nnnn'
Note that c2xx and c3xx have 'big' values while the others are small (mostly 0, kinda rare between 10-50).
So maybe both values should be at the bottom?!
first_byte_in_ms_mean_value is in milliseconds while bytes_received and bytes_sent are bytes.
Is it possible to have all values in just one graph? Or does it looks too bad? Else use two.
There should be a nice legend. The default one is bad, because it it clear that we only have values for one host!
So it should be something like '<yellow>: Codes for success (c2xx)'
Yes, if the DB schema is bad for this we can change it!