Hi there!
I was wondering if there was a way to dropping the first point in the visual builder as it messes up with the whole graph.
Let me explain:
I'm trying to calculate the rate of queries per second based on the pg_stat_statements from metricbeat's module's postgresql.
There is an exported variable that is called statement.query.calls which is the number of times the query has been called. This number is monotonic until there is a flush with the stats (or a restart but I'm not sure).
So in order to calculate the rate of the qp/s of all the queries, I do a sum. Since it's a time series, I plot it on a date histogram.
The issue is that if I don't specify the unit -- which is every 10 sec -- the first bucket will be false because the time range will not be precise.
As you can see, the first one is incorrect, but the second one is.
Here's another example:
In the two examples, you see that the first bucket is not like the other ones. It's a simple
bucket sum and sum aggregation to show that the behavior is from elasticsearch and I think it right.I'm looking for a way to drop the first one so the
derivative will make more sense.
Last thing: yes I could set the interval to 10s but if I want to zoom out to the last hour, the graph has too many variations on it.
Thank you for your help!
Amazing product!!!