# Automating Monthly Statistics
**URL:** https://forums.knack.com/t/automating-monthly-statistics/11011
**Category:** Ask the Community
**Created:** [September 1, 2021, 10:45am UTC](https://forums.knack.com/t/automating-monthly-statistics/11011 "2021-09-01T10:45:26Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Greg](https://forums.knack.com/u/Greg)
#### Post date: [September 1, 2021, 10:45am UTC](https://forums.knack.com/t/automating-monthly-statistics/11011/1 "2021-09-01T10:45:26Z")
Hi.
I’m using Knack to manage memberships of a club.
I have an object - Membership Statistics - that is manually updated every month with a snapshot of counts of different types of memberships (Individual, Family, Honorary etc). This is done via a page where a query creates a table by a filter on each membership type, and displays the count for each table. At the bottom of the page is a form where we manually copy these counts into each field on an edit form and on pressing Update it adds a new row to the stats record.
It struck me that this should be automatable. Can anyone point me in the direction of what I would need to do to create a task that on running (once per month), will get a count of records returned by a set of queries and create a new row in the statistics records?
Thanks,
Greg
---
### Author:  [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)
#### Post date: [September 1, 2021, 10:58am UTC](https://forums.knack.com/t/automating-monthly-statistics/11011/2 "2021-09-01T10:58:28Z")
Hi Greg
In general, Knack will only give you stats like this though Sum and similar number features which rely on connections in the database. I don’t think this would work in your case because these are snapshots per month I think?
My choice would be to use [Integromat](https://www.integromat.com/?pc=kirkness), running a monthly ‘Scenario’ to calculate the required figures and creating a monthly stats record. You could use a series of Knack Search for Records Modules with criteria to select the types of records you need and then create a new record in Stats using the Number of Bundles figure from each search as the value.
Please contact me directly if you would like help with this.
Julian
---
### Author:  [@Greg](https://forums.knack.com/u/Greg)
#### Post date: [September 1, 2021, 11:24am UTC](https://forums.knack.com/t/automating-monthly-statistics/11011/3 "2021-09-01T11:24:37Z")
Hi Julian,
Thanks for the tip. I was hoping to be able to do it within Knack itself, but from what you are saying that’s not possible.
We already have a number of actions via Zapier integrations - is there anything special about Integromat, or would Zapier provide me similar control? I would prefer not to take out yet another subscription if possible.
Greg
---
### Author:  [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)
#### Post date: [September 1, 2021, 4:42pm UTC](https://forums.knack.com/t/automating-monthly-statistics/11011/4 "2021-09-01T16:42:59Z")
Hi Greg
I would really recommend anyone to use [Integromat](https://www.integromat.com/?pc=kirkness) instead of Zapier wherever possible. It really has far more functionality especially in terms of processing multiple records at one time (which would be required here). I have written a number of posts about using Integromat with Knack which you may find useful:
> **[Knack](https://www.onlinedatabase.expert/blog/categories/knack)**
>
> Visit our Blog where we review database and other cloud / online platforms and where you can comment.
Increasing numbers of Knack Experts (members of the Expert Network) like me are also Integromat partners and use it on a regular basis as a no code automation tool for Knack - not just an integration tool.
Julian
---
### Author:  [@Greg](https://forums.knack.com/u/Greg)
#### Post date: [September 1, 2021, 8:20pm UTC](https://forums.knack.com/t/automating-monthly-statistics/11011/5 "2021-09-01T20:20:52Z")
Hi Julian.
Thanks for the suggestion. I will take a look, and have a read of your posts too - look really useful.
Greg