In eazyBI information on status categories is already pulled in and there is no need to define calculated measures to group statuses by category. In dimensions Status and Transition Status, is hierarchy Category that groups all statuses by status categories To Do, In Progress and Done (see picture below).
@cybertachikoma,
The status category is imported only in the Status and Transition Status dimensions, not as a measure. A category is the property (attribute) of each status, and that property allows group statuses.
Each issue contains the identifier of the status but no other properties like status name or status category:
[Issue].CurrentHierarchyMember.get('Status ID')
If you would like to show the statute category for each issue, then you can use an expression like this:
--in Status dimension Category hierarchy, look for Status matching status ID assigned to issue
[Status.Category].[Status].getMemberByKey(
[Issue].CurrentHierarchyMember.get('Status ID')
--for that status, get the parent (category) name
).Parent.Name
I am trying to make the same calculation field as you showed for Category, but for Sprints. I need to create a calc field for Sprint dimension that will show all sprints groups for one year.
Each sprint cycle contains a lot of sprints for different teams, so I need to be able select one year in Rows panel, then see something like:
All 2022 sprints / sprints by their number / groups within one sprint
Is it possible to create such custom field? So far I could only make All 2022 sprints / groups within one sprint
@Alsu_Zaynutdinova grouping sprint by their parameters is a different use case than showing the statutes category name for each issue and requires another solution.
You might want to check out other Community topics related to Sprints and methods to group them by name or other properties: