Sorting values in a chart

[MichaelLe1]

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

[DagmaraGa]

I was trying to get the same results.. but it looks like at the moment there is no option like this.

[DavidCo3]

Hi - to my knowledge, this is not possible but it would be a good feature request!

[TimWa]

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

[NinaZa2]

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

[NickVa1]

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.  

[LisaRi6]

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

[Rwchambe]

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.