Track Completed Projects by Month
I feel like I have the data I need in order to chart projects completed by month. I have a date completed column and several columns I could use to show complete/incomplete. However, when I try to put into a chart, it does not pick up the date or display how I want to. I only want to chart this level 1 data for now. Here is a screenshot of my sheet:
Best Answer
-
Hey @Curculese,
When I did something like this previously I think I had to create a separate "Metrics" sheet with 1 column being numbers 1-12 (for months), then I had a COUNTIF column next to that that would count the number of cells with MONTH():
=COUNTIF({Date Completed}, MONTH(Month@row))
Then pull that sheet data into the dashboard. Hopefully that makes sense!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Have you tried creating report(s) that refer to this Sheet and then create a chart from the report(s)?
-
I have created reports that include various columns. However, when I try to chart it, it does not recognize the dates at all and charts each "1" individually.
-
Hey @Curculese,
When I did something like this previously I think I had to create a separate "Metrics" sheet with 1 column being numbers 1-12 (for months), then I had a COUNTIF column next to that that would count the number of cells with MONTH():
=COUNTIF({Date Completed}, MONTH(Month@row))
Then pull that sheet data into the dashboard. Hopefully that makes sense!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
I will have to play with this… One problem is that some of it was done in a previous year and the rest will continue over this year and into the next… I'm not sure if that means numbering 1-20 or something and then just renaming columns in the chart. But this is helpful, thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives