Why is my sheet not showing up as a data source for a metric widget

Hello,

I have two sheets in a workplace as show below.

However, when I go to add a metrics widget to the dashboard only one sheet shows up as a potential data source.

How do I get the other sheet to show up as a data source. As of now the metrics sheet is a column of descriptions, then a column of the calculations. The calculations are based off the tracker data. Any insight would be great.

Find more posts tagged with

Sheets

Dashboards

functionality

Metric Widget

Accepted answers

All comments

Shawn Cullen

With out looking at your sheets, its hard to trouble shoot at the cause. One suggestion is that if your summary section on the grid view, you can easily either create a summary report for the dash board or it would also work easily with the metric widget.

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.