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

  • Austin Smith
    Austin Smith ✭✭✭✭✭

    @Dom Yap

    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.