Dropping first point sum aggregation visual builder

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

This is not currently possible. You can open an enhancement issue at https://github.com/elastic/kibana/issues/new?template=Feature_request.md

Thank you so much for the answer @Nathan_Reese!
I will open the feature request. (https://github.com/elastic/kibana/issues/30170)

I am considering having another process that would export the query count in the meantime.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.