On this page:
...
| Transitions to status | How many times during selected Time dimension period issue has been transitioned to the status that is selected in Transition Status dimension (or only transitions that are selected in Transition dimension). Also, first issue status will be counted in this measure on issue creation date. If you would like to see a distinct (unique) count of issues for these transitions then use Transitions to status issues count measure from the Distinct issues count measure group. |
|---|---|
| Transitions from status | How many times during selected Time dimension period issue has been transitioned from the status that is selected in Transition Status dimension to different status (or only transitions that are selected in Transition dimension). If you would like to see a distinct (unique) count of issues for these transitions then use Transitions from status issues count measure from the Distinct issues count measure group. |
| Transitions to | Hidden measure. How many times during selected Time dimension period issue has changes to some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes If you would like to see a distinct (unique) count of issues for these transitions then use Transitions to issues count measure (hidden measure). You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Transitions from | Hidden measure. How many times during selected Time dimension period issue has changes from some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes If you would like to see a distinct (unique) count of issues for these transitions then use Transitions from issues count measure (hidden measure). You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Transition to first timestamp | Hidden measure. Shows the timestamp of the first transition to some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes. You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Transition to last timestamp | Hidden measure. Shows the timestamp of the last transition to some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes. You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Transition from first timestamp | Hidden measure. Shows the timestamp of the first transition from some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes. You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Transition from last timestamp | Hidden measure. Shows the timestamp of the last transition from some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes. You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only. |
| Days in transition status | Use this measure for individual issues to show how many days issue has stayed in status from Transition status dimension. It is calculated when an issue is transitioned from this status (when the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened. Use Average days in transition status calculated measure when you are analyzing totals of many issues. |
Workdays in transition status | Similar to Days in transition status but only workdays are calculated according to Time dimension options. |
| Transitions to status issues count | How many (unique) issues have transitioned to selected status in Transition Status dimension (or only transitions that are selected in Transition dimension) during the period chosen in Time dimension. The measure is located in Distinct issues count measure group. |
| Transitions from status issues count | How many (unique) issues have transitioned from selected status in Transition Status dimension (or only transitions that are selected in Transition dimension) during the period chosen in Time dimension. The measure is located in Distinct issues count measure group. |
...
| Issues history | How many issues at the end of selected Time dimension period are
|
|---|---|
| Average days in transition status | Average days that issue stayed in status that is selected in Transition status dimension. It is calculated when an issue is transitioned from this status (when the the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened. |
Average workdays in transition status | Similar to Average days in transition status but only workdays are calculated according to Time dimension options. |
| Transition to status first date | Shows the date and time when the first transition to the corresponding Transition Status (or the selected Transition) was performed. |
| Transition to status last date | Shows the date and time when the last transition to the corresponding Transition Status (or the selected Transition) was performed. |
| Transition from status first date | Shows the date and time when the first transition from the corresponding Transition Status (or the selected Transition) was performed. |
| Transition from status last date | Shows the date and time when the last transition from the corresponding Transition Status (or the selected Transition) was performed. |
| Transition to assignee | How many times during selected Time dimension period issue has been assigned to the user selected in Assignee dimension. |
| Transition from assignee | How many times during selected Time dimension period issue has been unassigned from the assignee selected in Assignee dimension. |
...
| Transition Status | All statuses that appear in workflow transitions (the same statuses as in Status dimension). For next-gen projects, transition status value is a combination of status and project key, like "In Progress (DEMO)". flex.bi also creates a secondary hierarchy By Name that groups transition statuses first by status name and then by project-specific status thus allowing to analyze all issues with the same transition status name across all next-gen and standard projects. |
|---|---|
| Transition | All individual transitions with names in the format “From status => To status”. For next-gen projects, statuses describing transition have value combined of status and project key, like "To Do (DEMO) => In Progress (DEMO)". flex.bi also creates a secondary hierarchy By Name that groups transitions first by transition name and then by project-specific transitions thus allowing to analyze all issues with the same transition name across all next-gen and standard projects. |
| Transition Author | User who performed the transition. |
| Transition Author Group | Corresponding Jira user groups of transition authors. If a user belongs to several Jira user groups then corresponding measure value will be included for all corresponding user groups in this dimension. |
| Assignee | Issue assignee at the moment when the transition was performed. |
| Sprint | If you import Sprint dimension from Jira Software custom fields then also Sprint changes will be stored and will show the sprint when the transition was performed. |
| Transition field | Hidden dimension that could be used in the calculated measures to limit changes to particular dimension only. For example. [Transiton field].[Sprint] will limit changes to Sprints only. |
...
flex.bi supports value changes import for single value custom field dimensions. Please add additional separate_table and changes in advanced settings for these custom fields:
| Code Block |
|---|
[jira.customfield_NNNNN]
data_type = "string"
dimension = true
separate_table = true
changes = true |
Use custom field ID instead of NNNNN in the definition above. Add the updated custom field definition to flex.bi advanced settings or ask Jira administrator or flex.bi admin to do this for you. flex.bi advanced settings are common for all accounts and only Jira administrators and flex.bi admins have access to the settings.
...