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.

Answers

  • Shawn Cullen
    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.

    Cheers,

    Shawn Cullen, MBA, RMT, PMP, GPHR, PHR, SHRM-SCP, LSSGBC

    Director Strategic Initiatives

    ADP - NAS Operations PMO