Counting records based on Created month

Joseph Aloysias - vSaaS Global

I want to count the records created based on "created month" column.

=COUNTIFS({Status}, [Primary Column]@row, {Created Month}, "APRIL 2023") I tried with to calculate for one month but I wanted to calculate for all 12 months,

parulmishra

You can try doing it in 2 ways... Create Two summary fields on as a dropdown having all the Months in it and the second one having the Countif Formula. As you keep on changing the Dropdown field value your count will keep on updating

parulmishra

If you are trying to do it for dashboard graph purpose you can try doing this.

Joseph Aloysias - vSaaS Global

Yes, I'm doing it for sales dashboard, we have overall data from 2010 to till date and I'm trying to show sales graph from Jan 2023 to Till date