Making Dashboards from forums
I am a project manager, working with other teams. Each week, we have a forum I need our team to fill out. Then I need to produce graphs based off that data. I have a few Questions:
1) How do I create S-Curve graphs based off the data that comes in from the forum?
2) How do I duplicate this forum week over week, archiving the old week, and pushing the new week?
Answers
-
Fellow Matt here, a common way to do this is to create another sheet for metrics. This sheet is usually a free form space to do calculations and arrange the data in different ways to accomodate the different graph/chart types.
The Form feeds a sheet and the Metric Sheet pulls information from that sheet. So maybe for date submitted, you add a helper column to the sheet, not the form, and the helper column pulls the =WEEK(Date Submitted@row). Then on your metric sheet you list all the WEEK numbers down one column and do a COUNTIF or COUNTIFS formula in another column to cound different things that relate to each week. Then you point the graph widget at the metric sheet to set up the graph.
I hope that helps.
Matt
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives