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!!!