Line chart by Created
Hello,
I am looking to add a line chart to my dashboard that shows how many projects have been opened by month for the past year. Any suggestions on how to accomplish this? I was also looking at the Work Insights new feature the Time Series widget but Created is not a column option.
Any assistance will be greatly appreciated.
Thanks,
Lara
Best Answer
-
The way I would do this is to add a helper column in the sheet(s) that you're looking to count. This column would extract the Month from the Created column like so:
=MONTH(Created@row)
Then create a Report with all of the sheets/rows and Group it by this Month column. Once you have it Grouped by Month you can use the Summarize function in the Report to COUNT how many rows are in each month. See: Redesigned Reports with Grouping and Summary Functions
Then you can use this Grouping/Summary line to automatically create a chart in your Dashboard!
Let me know if this makes sense and works for you.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
The way I would do this is to add a helper column in the sheet(s) that you're looking to count. This column would extract the Month from the Created column like so:
=MONTH(Created@row)
Then create a Report with all of the sheets/rows and Group it by this Month column. Once you have it Grouped by Month you can use the Summarize function in the Report to COUNT how many rows are in each month. See: Redesigned Reports with Grouping and Summary Functions
Then you can use this Grouping/Summary line to automatically create a chart in your Dashboard!
Let me know if this makes sense and works for you.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you Genevieve, really appreciate your help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives