Formatting question for dashboard chart elements - display series as percentage.

I created a Summary Report from a sheet with formulas used to calculate completion percentages for different departments - these summary fields are formatting for percentage and shows as a percentage in the summary fields and in the Summary Report. I created a column chart widget to visualize these percentages, and the axis also shows the values with the % sign. HOWEVER, when I hover my cursor over each column, the value displayed is the decimal number. The values are formatted for percentage throughout, so I'm not sure why the series doesn't format as well.

And showing the series label is not an option due to the limitations of chart axis - if I add the label, it automatically changes the y-axis scale to 120%, when I need it to max at 100%.

And I even created a metric sheet to pull in the same formulas as the summary fields, thinking maybe assigning the columns to Percent there and then referencing this for the chart widget would force it, but it still only shows the decimal/whole numbers. Any ideas?

Find more posts tagged with

Accepted answers

All comments

JR90

Could you show a screenshot of your chart and the data that is being used for it?

Thanks

KarenTF

This is the Sheet Summary with formulas to calculate and formatted for percentage:

This is the Summary Report created for the summary field values above:

This is what I see on the graph when I hover over the column:

If everything is formatted for Percent even the y-axis, why is this not showing up as a percentage as well?

JR90

I tried to recreate this with my own data and dashboard and I'm unable to, every time I hover over a column it is formatted the same as the Y axis whether it's in decimals or a percent. This leads me to believe that this might be a Smartsheet issue because the way you have it set up looks fine. @Paul Newcome did you have any thoughts on this?

Matt Lynn ACT

@KarenTF
I think I'd need to dig/troubleshoot a bit or maybe my coffee just hasn't kicked in fully yet… the only thing that comes to mind initially is I've had similar things occur when one random cell in the data wasn't formatted as a %. So let's say 1000 rows of data is a % but one somehow got put in as a non-decimal or % and it messes with the charts. But that's a wild guess/suggestion.. had that happen many times.

Also randomly/selfishly… would be interested to see how you do/use GEMBA as a process. I've built some GEMBA stuff recently and curious to learn more as it can be done several ways.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.