Forum Discussion
Sort legend
I assume the "bucket" column you put in Legend should be based on another numeric column. You can't directly have this "Bucket" column sort by that numeric column.
In this scenario, you can create another sort table like:
Bucket Order Early 1 On time 2 5 - 10 days 3 11 - 15 days 4 16+ days 5 Then build the relationship to your existing table on Bucket column, and use "merge queries" to join the Order column into existing Query. Now you should be able to have the Bucket column sort by Order column.
Regards,
Regardless of whether you relate the tables or merge them:
1. Select your "Response" field
2. Select the "Sort by Column" button
3. Select your "Order" column
Hello,
I tried out what you suggested but the option to sort by 'Order' isn't showing. I've added some screen shots to show how I've created the relationship and that I've merged the tables to add 'Order' to my survey data.
Where have I gone wrong?
Shot showing that I've merged the queries, successfully i think?Shot showing the relationship I've created between the two tables. Linking responses togetherShow showing that when I have responses selected the 'Sort by' option is showing 'Order' as an option