Give users the ability to sort in bar chart

[#1]

I have a bar chart with one dimension and three expressions. I want to provide users the ability to display the dimension in the order they want. Is this possible.

For example if my dataset is

CITY                   SCORE

HOUSTON        100

BOSTON            50

New York           150

LA                        20

I want to provide users the ability to order the cities on the X axis as they wish (ex: New York, Boston, LA, Houston). Is this posssible. My dataset is dynamic, the records for the dimension will change very frequently, so I am not able to hardcode the sort order, therefore want the users to choose.

[sunny_talwar]

Are there few ways you want them to sort City? For example few of the ways could be ascending, descending, by score etc. If there is a finite number of ways you want them to be able to sort it, then it might be possible. But if you want to be at user's discretion, then I am not sure if there is a way.

Others please contribute.

Best,

S

[#3]

Is it possible to sort X axis in the order that dimension values are selected. As the user selects from the listbox, I want the dimension to be sorted in that order.

[sunny_talwar]

Unfortunately, I am not aware of a way to do it.

Best,

S

[simospa]

You could create 2 chart, one ordered in a way and one in the other (i.e.: one with cities ordered by descending and one ascending). Then you can put a simple list with two values and then in one condition you view a chart and hide the other and so for the second choise.

See the attachment.

Simone.

[#6]

Thank you, but unfortunately this does not work for my requirements. This is still predefining the order.

[MarcoWedel]

Hi,

one possible solution could be:

hope this helps

regards

Marco

[jonasheisterkam]

Hi, here is a other approach.