Chart from Metric sheet

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!

Find more posts tagged with

Reports

Dashboards

Accepted answers

All comments

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.

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.