About the display order of graphs on the dashboard

Hello all smart seat enthusiasts.
I would like to borrow your wisdom today as well.

When sourcing data from a report and creating a graph in a dashboard. Is it possible to sort the results in ascending order? Although I can sort the numbers for each row, I am having trouble displaying them in the order of the aggregated results of the groups.

If there is a solution, please let me know.

Find more posts tagged with

Dashboards

Accepted answers

All comments

Antonie B

@Marina_123 ,

Great Question! You should be able to apply sorting on the Report, there is an article that explains that in more dept here: https://help.smartsheet.com/articles/2482084-sort-your-report-results-with-report-builder

If you need to manually influence this, you can a helper column to help drive the sorting by adding labels from A to Z, this can be done manually or using a formula to build in the parameters. I would not use numbering, as the logic in Smartsheet will look at the first value so you would end up with 1,10,11,2,3,4 etc.

I hope this helps?

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.