How do I create a rank to dynamically control my bar chart?

[duncan]

Hello @July

Are you still working on this or were you able to find a solution?

I think that @prantika_sinha 's example above is the closest solution but I’m not sure I totally understand the end objective. To clarify, you want a stacked bar chart with 6 segments sorted from highest to lowest, with the first 5 being actually category names and the 6th saying “Other” by month.

If the above is the case, ultimately, I don’t think there is a way to control the order of the segments in the bars via sort orders in the field well. It seems to be based on alphabetical/numeric order of the field value i.e. A, B, C, D or 1, 2, 3 etc… This topic still has what I think is the best solution:

How do you sort stacked bar chart by value

Hi @sambhavbhandari - Currently QS will not sort the Group/Color using a value. Here is a workaround that you can use. Step 1 - Create a calculated field that will show your stacked group plus what rank the value is. c_rank: rank([value DESC],[col2], PRE_AGG) Step 2 - Concat your rank + your stacked group. c_sort_col1_string: concat(tostring({c_rank}),col1) Step 3 - Change the legend colors so that all stacked groups are the same color. Step 4 - Hide the legend and create your own lege…