Chart from Metric sheet

Options

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!

Answers

  • Jason P
    Jason P ✭✭✭✭
    Options

    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….

    Cheers.

    Forever forwards Backwards never.

  • Jess D
    Jess D ✭✭
    Options

    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
    Jason P ✭✭✭✭
    Options

    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.

    Cheers.

    Forever forwards Backwards never.