# Count of each API in a different table **URL:** \ **Category:** Elasticsearch\ **Created:** [October 26, 2020, 12:13pm UTC](https://discuss.elastic.co/t/count-of-each-api-in-a-different-table/253302 "2020-10-26T12:13:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rohitarorait82](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rohitarorait82/32/82981_2.png) [@rohitarorait82](https://discuss.elastic.co/u/rohitarorait82)\ **Post date:** [October 26, 2020, 12:13pm UTC](https://discuss.elastic.co/t/count-of-each-api-in-a-different-table/253302/1 "2020-10-26T12:13:38Z")
Hi All, We need to create a table where we can store daily counts of all the apis. We actually keep data of around 1 month in ELK but will be needing count details for around an year for analysis. Is there a way to do that. ---
**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\ **Post date:** [October 26, 2020, 12:28pm UTC](https://discuss.elastic.co/t/count-of-each-api-in-a-different-table/253302/2 "2020-10-26T12:28:24Z")
There are two ways to approach this, please take your time to read about both and see which one fits. your use case. It's rollups and transforms, see the documentation at [https://www.elastic.co/guide/en/elasticsearch/reference/7.9/data-rollup-transform.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.9/data-rollup-transform.html) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 23, 2020, 12:28pm UTC](https://discuss.elastic.co/t/count-of-each-api-in-a-different-table/253302/3 "2020-11-23T12:28:28Z")
Closed on November 23, 2020, 12:28pm UTC This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.