Forum Discussion
MarkShnier__You
2 years agoQrew Champion
I think the easiest way to do this is to make a new formula field to calculate the month number.
Month([my date field])
Then for that summary report you would just have the Rows being the date grouped by Year and the columns being that calculated month number.
The chart you should be able to set the Y axis as the Month # and then set the "Series" as the Year - you will probably need to create a calculated field for the Year like
Year([my date field])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Month([my date field])
Then for that summary report you would just have the Rows being the date grouped by Year and the columns being that calculated month number.
The chart you should be able to set the Y axis as the Month # and then set the "Series" as the Year - you will probably need to create a calculated field for the Year like
Year([my date field])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------