We have a select list in jira with the following options:
When we do a report with them, they are ordered like this.
I understand that eazybi orders them like this because it considers the numbers a text field. But, is there any way to order them according to number?
You can create an aggregate in your “Custom field” dimension where you define the custom rules to order the set of members by creating a calculated dmember: Calculated members in other dimensions.
In your example, you could try using regular expressions to find the integer between the “-” and use it as a number to sort members by numbers (instead of default order by string Number+text).
Try it in two steps:
step1. create new calculated member “All but none”
[CF name].[CF name].Members,
step2: create the next calculated member
Childrenset([CF Name].[All but none]),
Here the “CF Name” is your field name and it must be imported as dimension.
Martins / eazyBI