# Integral function leads to incorrect grouping issue

**URL:** <https://community.influxdata.com/t/integral-function-leads-to-incorrect-grouping-issue/14004>\
**Category:** Dashboards\
**Tags:** influxdb, grafana\
**Created:** [April 23, 2020, 3:48pm UTC](https://community.influxdata.com/t/integral-function-leads-to-incorrect-grouping-issue/14004 "2020-04-23T15:48:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Derevyanko](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/michael_derevyanko/32/4742_2.png) [@Michael\_Derevyanko](https://community.influxdata.com/u/Michael_Derevyanko)\
**Post date:** [April 23, 2020, 3:48pm UTC](https://community.influxdata.com/t/integral-function-leads-to-incorrect-grouping-issue/14004/1 "2020-04-23T15:48:11Z")

</div>

I want to calculate the throughput, using the formula `Throughput = (number of requests) / (total time).` To calculate the total time I’m using the integral function - [InfluxQL functions | InfluxDB OSS 1.7 Documentation](https://docs.influxdata.com/influxdb/v1.7/query_language/functions/#integral). And I faced with the issue - grouping doesn’t work as expected when adding the integral to the query and select other things at the same time.  
It leads to an issue in calculations:  
`SELECT count(count)/integral(count) as Throughput FROM "requestsRaw" WHERE "requestName" =~ /->/ AND "requestName" !~ /^SCRIPT/ AND $timeFilter GROUP BY requestName`

 ![issue2](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/2/24eccf8348ca39cf248cf8dad8fa9a42c675e452.png)  
But the correct table with the right grouping is displayed when using two queries instead of one. Could you please help?

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [April 24, 2020, 6:05pm UTC](https://community.influxdata.com/t/integral-function-leads-to-incorrect-grouping-issue/14004/2 "2020-04-24T18:05:13Z")

</div>

Hello @Michael_Derevyanko,  
I’m a little unclear about the issue that you’re having. Could you share your input and your expected output? Why did you use integral to calculate the total time? Perhaps [elapsed()](https://docs.influxdata.com/influxdb/v1.7/query_language/functions/#elapsed) could work better for you? Thanks!