Adding graph and counts to a dashboard

Dana234

Hello there! I am looking to add to meeting dashboard. I have a sheet tracking our quarterly goals (seen below) and a dashboard for our weekly team meeting (also seen below) - what I would like to do is add a count of goal health per person- X amount of goals in the green, x in red, x in blue, etc. The summary of goals I created is just a report - but I think a count might actually be more useful.

Thank you!

Dashboard Goal Snap Shot:

Quarterly Goals Source Sheet

Dana234

Thanks! I think I figured out most of it in the metric sheet! Still learning the ins and outs of the best way to set these up, but half the fun is experimenting right? Thanks for the advice !

MedaUser

Hi @Dana234,

I would strongly suggest you create a Metric Sheet that does the calculation(s) for you. This allows you to have more flexibility with your graphs and widgets when creating a dashboard. Your metric sheet would include a table that counts the health by person, so your graphs will be able to map to an X/Y axis graph. You can create other metrics on this sheet that you can select when mapping to other graphs/widgets you might want to add to your dashboard as well.

Hope this helps!

Dana234

Thanks! I think I figured out most of it in the metric sheet! Still learning the ins and outs of the best way to set these up, but half the fun is experimenting right? Thanks for the advice !

MedaUser

Absolutely! Enjoy experimenting!