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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives