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
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
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
sumaggregation to show that the behavior is from
elasticsearchand I think it right.
I'm looking for a way to drop the first one so the
derivativewill 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!