Sorting values in a chart | Community
Skip to main content
M
MichaelLe1
May 17, 2017
Question

Sorting values in a chart

  • May 17, 2017
  • 6 replies
  • 1361 views
Can anyone help me with understanding how to sort the values that display in a Workfront chart, specifically a bar chart. I have a chart that shows record count for projects on y-axis with Sponsor name as the x-axis (see image). Would like to show it in descending order of record count. Thanks, Michael
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    6 replies

    D
    DagmaraGa
    Level 9
    May 22, 2017
    I was trying to get the same results.. but it looks like at the moment there is no option like this.
    D
    DavidCo3
    Level 10
    May 22, 2017
    Hi - to my knowledge, this is not possible but it would be a good feature request!
    T
    TimWa
    Level 2
    March 27, 2018
    I searched for sorting by value in a chart and found this discussion. I feel I must be misunderstanding but are we saying that there is no way to sort a chart by a numerical value? This seems like a basic function of a chart to me. Did anybody submit something in Idea Exchange? Tim Watts Disney Institute
    N
    NinaZa2
    August 2, 2024

    I still do not see what Workfront incorporated this capability, unfortunately.

    N
    NickVa7
    Level 9
    October 7, 2024

    Can confirm I would like this functionality too.  I've tried updating Groupings by adding sortOrder=desc (for descending order) and it's not reflected on my charts.  Too bad.  

    L
    LisaRi6
    New Member
    October 11, 2024

    I need to Sort by Specific values so would love to know if this is doable

      R
      Rwchambe
      New Member
      August 29, 2025

      One option that may work depending on the data is to update you custom field to show the value and prefix the value with a number you want to sort by.

       

      In my case the field was "Anticipated Cost" and the single select options were <$100k, $100-250k, $250-500K, $1-2M, etc. The chart is doing an alphabetical sort. I updated the single select field values to 1 <$100k, 2 $100-250k, 3 $250-500K, 4 $1-2M....

       

      The leading numbers are not display and it got me the order that I wanted. If you were doing math or anything else with these values then this wouldn't work. 

      Terms & ConditionsAccessibility statement

      Loading footer...