# Transaction per second, agg last 15 minutes

**URL:** https://discuss.elastic.co/t/transaction-per-second-agg-last-15-minutes/229645
**Category:** Elasticsearch
**Created:** [April 24, 2020, 12:12pm UTC](https://discuss.elastic.co/t/transaction-per-second-agg-last-15-minutes/229645 "2020-04-24T12:12:35Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Elad\_Ben-aderet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elad_ben-aderet/32/66855_2.png) [@Elad\_Ben-aderet](https://discuss.elastic.co/u/Elad_Ben-aderet)
#### Post date: [April 24, 2020, 12:12pm UTC](https://discuss.elastic.co/t/transaction-per-second-agg-last-15-minutes/229645/1 "2020-04-24T12:12:35Z")

</div>

I have the "action" field, I want to query last 15 minutes  
and get the avg 'transactions' for every action type every (interval) seconds.

I made this but it gives me just the last minute result

```auto
 body: {
   size: 0,
   query: {
     bool: {
       must: [
         {
           range: {
             '@timestamp': {
               gte: from,
               lt: to,
             }
           }
         }
       ]
     }
   },
  aggs:{
    {
      agg1: {
        date_histogram: {
          field: '@timestamp',
          interval: '5s',
          aggs:{
             sub_agg1: {
               terms: {
                 field: "action",
                 aggs: {
                   stats_aggregation: {
                       stats: {
                         field: "avg"
                        }
                     }
                 }
              },
            }
          }
        }
     }
    }
  }
 }

```

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 22, 2020, 12:12pm UTC](https://discuss.elastic.co/t/transaction-per-second-agg-last-15-minutes/229645/2 "2020-05-22T12:12:35Z")

</div>

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