Forum Discussion
Solved
Group dates by month and then chart
I have a bunch of form entry dates exported that look something like:
4/29/2023 13:21
4/27/2023 1:55
4/20/2023 17:23
4/4/2023 14:50
3/5/2023 6:11
2/18/2023 19:34
2/2/2023 12:42
2/1/2023 8:08
12/4/2022 7:35
etc....
I want a bar chart to show form fills over time, but grouped by month. So eg. the bar would show April 23 with 4 entries, etc... How to do this?
7 Replies
- Thank you. Is there a way to have G, H, I columns generated? I have hundreds of entries so it would be impractical to do manually.
- You could table the source data and then source the pivot table from the table. All you'd have to do is refresh the pivot when new data comes. Are you looking to pull back G-H-I with a formula?
