Jira Service Desk custom field import
If you use Jira Service Desk, then in Jira import custom field selection you can select which Service Desk SLA custom fields as well as other custom fields to import.
For each selected SLA all dimensions and measures described below will be imported (this feature is available starting from the eazyBI version 4.4). Satisfaction and Satisfaction date can be imported in various ways creating a dimension, different measures and properties (this is a new feature available starting from eazyBI version 4.7). See below the detailed description of measures and properties created with the Satisfaction data.
In addition, you can also import the following additional Jira Service Desk custom fields:
Customer Request Type
Can be imported both as a dimension and as a property and shows the display name of customer request type.
Can be imported both as a dimension and as a property and shows the additional service request participants that are added to the issue.
|Organization||Can be imported both as a dimension and as a property and shows the organization of the issue.|
|Channel||Can be imported both as a dimension and as a property and shows the customer channel of the issue (available starting from eazyBI version 4.7)|
Imported dimensions, measures, and properties
After data import, for each SLA metric a separate set of dimensions and measures will be created (SLA corresponds to the name of the imported SLA metric):
Shows SLA status: Running, Paused, or Completed. If the SLA is not applicable to the issue then the value is (none).
SLA State is assigned to each SLA cycle of the issue, and, accordingly to used measure, shows SLA State of current (ongoing) cycle, or historical Completed state as a lot of measures are calculated only for completed cycles.
Shows if the issue SLA cycle was or was not breached – Breached or Not breached (or (none) if not applicable).
SLA Breached is assigned to each SLA cycle of the issue, and, accordingly to used measure, shows if the current (ongoing) or last cycle is breached or not, or if the completed historical cycles are breached or not.
SLA Issues measure shows the total number of issues with the corresponding SLA information.
These issues either have an ongoing SLA cycle (then the issue is in the SLA State Running or Paused and the measure is not assigned to any Time dimension period) or have at least one completed SLA cycle (then the issue is in the SLA State Completed and the measure is assigned to the Time dimension period when the last SLA cycle was completed).
|SLA Elapsed hours|
The measure SLA Elapsed hours shows the total amount of elapsed hours for all completed SLA cycles. The measure is assigned to the Time dimension period when the SLA cycle was completed
|SLA Completed cycles||The measure SLA Completed cycles shows the total number of completed SLA cycles. The measure is assigned to the Time dimension period when the SLA cycle was completed.|
|SLA Completed cycles issue count|
The measure SLA Completed cycles issue count shows the unique count of issues that correspond to SLA completed cycles (if one issue has several SLA completed cycles in the selected Time period then it will be counted just once).
|Average SLA Elapsed hours|
The calculated measure Average SLA Elapsed Hours shows the average of elapsed hours for all completed SLA cycles (as SLA Elapsed hours divided by SLA Completed cycles).
SLA calculated measures
It is recommended to use the default calculated measures which are created for each imported SLA:
|SLA - Met||Number of issues which have not breached SLA (SLA Issues with the SLA Breached value Not breached).|
|SLA - Breached||Number of issues which have breached SLA (SLA Issues with the SLA Breached value Breached).|
|SLA - Met %||Percentage of issues which have not breached SLA.|
|SLA - Breached %||Percentage of issues which have breached SLA.|
SLA - Average hours
Shows the average of elapsed hours for all completed SLA cycles (as SLA Elapsed hours divided by SLA Completed cycles).
Issue SLA properties
|Issue SLA State|
The property Issue SLA State shows the current SLA status for individual issues (detailed Issue dimension members) – Running, Paused, or Completed.
|Issue SLA Breached|
The property Issue SLA Breached shows the current SLA breached / not breached status for individual issues (detailed Issue dimension members) – Breached or Not breached (or empty if not applicable).
|Issue SLA Due date|
The property Issue SLA Due date shows the calculated SLA due date (when SLA will be broken) for individual issues (detailed Issue dimension members).
|Issue SLA Elapsed hours|
The property Issue SLA Elapsed hours for individual issues (detailed Issue dimension members) shows the detailed information of completed SLA cycles as a multiline string with comma separated values – when the cycle was completed if it breached or didn't breach SLA, and the amount of elapsed hours for this cycle.
Issue Customer Request Type
The property Issue Customer Request Type shows the display name of customer request type.
Issue Request participant
|The property Issue Request participants shows the additional service request participants that are added to the issue.|
Satisfaction dimension, measures and properties
Satisfaction import is available starting from the eazyBI version 4.7 for Jira Server and in eazyBI for Jira Cloud.
Satisfaction dimension groups the issues by the satisfaction survey result values. The dimension members are the choices of the satisfaction survey. If the issues has not received the satisfaction result, those are grouped in the "(none)" member.
The measure Satisfaction resolved shows the total satisfaction value of the resolved issues. The measure is mapped to the time dimension by the issue resolution date.
The measure Satisfaction closed shows the total satisfaction value of the closed issues. The measure is mapped to the time dimension by the issue closing date.
|Satisfaction with satisfaction date||The measure Satisfaction with satisfaction date is created when the Satisfaction date is selected to import as a measure. This measure shows the total value of the satisfaction and is mapped to the time dimension by the satisfaction response date.|
|Issues with satisfaction date||The measure Issues with satisfaction date is created when the Satisfaction date is selected to import as a measure. This measure shows the number of issues having the satisfaction response and the number is mapped to the time dimension by the satisfaction response date.|
The Satisfaction property shows the value of the satisfaction survey selected by the issue reporter at the issue resolution.
|Satisfaction date||The Satisfaction date property shows the date when the issue reporter selected the satisfaction survey value|
Reporting on current or historical SLA data
For one issue, there might be several SLA cycles in different states (some completed and one ongoing) having different breached / not breached results.
If the reporting must be done by the issue latest or current SLA cycle results, then the SLA Issues measure should be used in the report together with SLA State or SLA Breached dimensions - then issues are counted by their current SLA status or whether the latest / current SLA cycle was or was not breached.
When measures SLA Elapsed hours, SLA Completed cycles, SLA Completed cycles issues count are used in the report, then they always are calculated from the issue all historical completed cycles (as these measures are stored just for completed SLA cycles). Also, these measures will be assigned to the historical value in the Assignee dimension (who was the assignee of the issue when the corresponding SLA cycle was completed). The historical assignee will be assigned only if the Import issue change history import option is selected.
If you selected the Import sample reports option, then additional sample reports are created in the Samples Jira Service Desk folder. For each selected SLA two sample reports are created. Please try these reports to see which measures would be useful for your specific needs. If you would like to customize some report then save it and change the name (as the default sample reports are overwritten during each Jira import).