Dashboard Widget to show completed items by month and year
Hi all,
I am trying to complete a dashboard item that was started by a colleague and starting to wonder if this is even able to be accomplished. Below are screenshots of what I am trying to achieve.
I am grabbing a column from a sheet and want to display it on a dashboard widget.
Answers
-
Easiest thing to do imo:
Make a helper column called Month with column formula =month([Actual Completion Date]@row)
Build out another sheet, or use summary data if you won't modify it much. =countif(Month:Month, month reference) then run a report on that column if you didn't build a separate sheet.
Then pull a chart on the summary data sheet/report. Should give you a clean, live data bar chart.
I have a general collector summary data sheet that I use for this exact purpose and it generates a lot of the charts that we use.
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