I want to order number of issues closed per assignee per month ASC or DESC. How to do this?
Welcome to the eazyBI community.
You might use the result of a measure to sort the rows.
You might read more about sorting rows by measures here - Create reports.
In order to have the entry groups on the Time dimension with the original sequence, you might create a new supplemental measure that holds both the start date in a numerical format and the actual value.
I would suggest creating it as a report-specific calculated measure named “ascending”.
The expression for such measure might be as follows.
DateToTimestamp([Time].CurrentHierarchyMember.StartDate)*1000+
[Measures].[Issues resolved]
After you have created this calculated measure in the Measures dimension, please add it to the report and sort rows by it.
After setting up the ordering clause, you might remove the supplemental measure from the report, but the ordering clause stays active.
Regards,
Oskars / support@eazyBI.com
