Metric Widget Column Header

I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Widget like how I use the Chart Widget, but am getting results like in the screenshot, attached, where the heading I am looking to use is added as data under the column heading and the data I wan under the heading I am looking to use is added under the column heading also.

Instead of:

Metric 1: % Complete

Metric 1: 38%

I want

% Complete: 38%

This is easily accomplished utilizing the Chart Widget. Is this possible utilizing the Metric Widget?

Thank you for your help and input.

metric widget columns.PNG

Find more posts tagged with

Healthcare

Reports

IT & Operations

Cell linking

Comments

Paul Newcome

Have you tried using multiple metrics widgets to pull individual data sets?

Ben Donahue

Paul,

Thank you for your time and help.

I am unsure what you mean; please elaborate. Do you mean to have many small widgets displaying the data in a key/value pair?

What I have resorted to doing is extending my metrics sheet and renaming the additional columns as the data name. So, renaming a column as "% Complete" and adding the data under that column. Far more work, but it will work.

How would your solution work?

Paul Newcome

Yes. I mean many small widgets. Although it seems as if you have already found a working solution. I generally end up using something very similar to your solution where I will build out a table using the data type/name as the column name.

Ben Donahue

Working solution, yes. The way the chart understands title/data is so elegant, I was hoping for similar functionality with the Metrics Widget.

Again, thank you for your time and help.

Paul Newcome

I agree. The differences in how a chart vs a metric widget recognize data are very different. I generally avoid metric widgets as much as possible just because of how the data is recognized and displayed.

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
How to recover data after I ran a new workflow and lost my data
The black arrow indicates when (around 4:30pm) the mistake was made. I would like to recover a previous version say around 2pm.
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct