# Dropping first point sum aggregation visual builder
**URL:** https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195
**Category:** Kibana
**Created:** [February 5, 2019, 9:35pm UTC](https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195 "2019-02-05T21:35:00Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@tehmoon](https://discuss.elastic.co/u/tehmoon)
#### Post date: [February 5, 2019, 9:35pm UTC](https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195/1 "2019-02-05T21:35:00Z")
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!!!
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [February 5, 2019, 10:57pm UTC](https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195/2 "2019-02-05T22:57:25Z")
This is not currently possible. You can open an enhancement issue at [https://github.com/elastic/kibana/issues/new?template=Feature\_request.md](https://github.com/elastic/kibana/issues/new?template=Feature_request.md)
---
### Author:  [@tehmoon](https://discuss.elastic.co/u/tehmoon)
#### Post date: [February 6, 2019, 12:39am UTC](https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195/3 "2019-02-06T00:39:49Z")
Thank you so much for the answer @Nathan_Reese!
I will open the feature request. ([https://github.com/elastic/kibana/issues/30170](https://github.com/elastic/kibana/issues/30170))
I am considering having another process that would export the query count in the meantime.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 6, 2019, 12:39am UTC](https://discuss.elastic.co/t/dropping-first-point-sum-aggregation-visual-builder/167195/4 "2019-03-06T00:39:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.