I have set of six pie charts on a dashboard that compare data between companies and highlight issues for actions.
The single dimension is a text value, created in a run script, that describes the issue.
I want each pie chart legent to be in the same sequence, regardless of text, frequency, load value etc. I want it to be dependant on the issue severity, but none of the regular sort features gives me what I need.
There are a maximum of 6 dimension values that have known content,
So for example, The values are A B C D E F and I want every pie chart to show the legend in the sequence..
ACDFEB
The only option seems to be the sort expression but the help text gives no guidelines on how to do what I want.
I could put a priority number in front of text in run script i,e,
1A 2C 3D 4F 5E 6B, but I want to avoid that if I can.
Does anybody know how I short format the sort expression to get what I need?
I have been through this post and have found many useful ways of sorting especially the post about sorting within a group dimension. Even so I am struggling with the group I have created in the attached example. The group is multilevel and needs to be sorted as follows:
1> Quarter-Year , needs to be sorted logically by year-quarter
2> TPP - Sort order is HCD,ECD,DCD,SCD (always does not matter what numbers they show except if one is 0)
3> Month - Logical
4> Days of the month - Logical
I have spent several hours trying to test this to be correct. Any help appreciated. MAny thanks.
I have the same kind of requirements. I have a slider, where i want to sort the months based on my requirements. However, The expression is disabled in the sort table, and i cannot sort it using expression. Do you have any idea why is the sort expression disabled? Can you please suggest any otherway to do it
