I am trying to sort dinamycally the chart below. The user must be able to select the weekday he wants to sort by. For example, if the user selects "Wed", the first value of the chart will be "Wed 01:00", then "Wed 09:00" and so forth (see chart).
I have asociated a numeric value for each value of the dimension and it can be sorted by that value with no problem, the problem now is to make it dynamic.
Not sure i understand 100% . If they select 'Wed' do you want to filter out 'Mon' and 'Tues' values but show Wed and everything after? I think your chart is already sorted in chronological / weekday order....
I want that if the user selects "Wed" on a listbox, the first value of the chart will be Wed 01:00 (the first hour for the day selected) and will go all the way to Sunday and then Monday, and then the last value will be Tuesday. It goes around the weekdays.