![Nathan_Ramey Nathan_Ramey](https://community.airtable.com/legacyfs/online/avatars/3X/8/2/8284e3b8cd0b7f92f50598cdc9645610313a619e.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 09:08 AM
Hello!
I am trying to create a graph to show how many records where submitted in each month of each year, and for some reason I just can't think of a way to accomplish this.
Example Jan 2020 =1, Feb 2020 = 3 .......... 12 2024 = 89, 1 2025 = 90 sorted in order
Anyone know how to do it?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 01, 2025 04:08 AM
Hey Nathan,
You can accomplish this directly within the graph without having to create an additional field.
When creating the bar graph to display how many records were submitted per month, simply select your date field in the X-axis and use the "Bucket by" option to bucket by "Month".
Let me know if that solves your issue!
-Matt
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)