Chart from Metric sheet

Jess D

Hi all!

One of the projects I am working on is using a metric sheet to roll up information. When I create a report from this, to then display on a dashboard, the report shows the column headers. Being a metric sheet, the column headers are generic (Column3, Column4, etc.) as the data within the column varies based on which section the row is in.

Is there a way to not show the column header in the report? Or is there a better way to handle it?

Here is an example from the metric sheet:

Within the same metric sheet is other data, for example:

Here is the report:

And here is how it shows on the dashboard:

Thank you for your thoughts and suggestions!

Jason P

Hi @Jess D

You cannot hide column names - you can change them in the dashboard report widget, would that work? it's not perfect but….

Jess D

Hi Jason,

Thanks for getting back to me! It looks like the screen shot is changing the title of the widget, not the column names. I tried to rename the columns within the report with no luck. I will see what other options I have.

Thanks again!

Jason P

Sorry Jess, I thought you wanted the change on the Dashboard. You cannot change the column name in a report as the data is pulled in from the sheet - you would need to change column name on the sheet.