Adding graph and counts to a dashboard

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

Find more posts tagged with

Dashboards

graphs

Accepted answers

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 !

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.