Auto-sort 100% Stacked Bar Graphs by percent

[Gregg_Bryan]

Hi,

I am looking to sort this graph so the site with the lowest % of No is on top then descend down in order. I feel like I may be overlooking something easy but have been stuck on this for over an hour. Any idea how to sort these graphs based on the percents in them?

Thank you in advanced!

[robdhondt]

Hi @Gregg_Bryan -

For this you can create a calculated field to find the % Nos. Then sort by it.
c_no_percent_site

sum(ifelse(answer='no',value,0))
/
sum(value)

Then sort options (this will let you select from all calculated fields)

Result: