I would like to report the timespan between certain values of a Jira custom field. Unfortenately, the custom field’s content is not well-defined, but the properties I am looking at are. Generally, the field has eight different values for various use cases, I am looking at three only. For the purpose of this topic let’s call them Start, Outcome1 and Outcome 2. The issues I am looking at always have one of the Outcomes and a Start. To be specific: I want to calculate the total in workingdays and the average.
Obviously, the date(time) of property value changes is not easy to access. I found several topics which seem to try something similar but they are several years old and I feel like I am missing out on some basic steps or prerequesites. I do not know which solution path to look into.
You can analyze the change history for a single value custom field in eazyBI.
First things first, import the change history for your custom field: Import issue change history
In import options, edit the advanced settings for the custom field. Add the settings in the field Additional advanced settings and save changes:
separate_table = true
changes = true
Perform double data import for the custom field to apply changes correctly (Advanced settings for custom fields).
Unselect the custom field and import data without it to clear the data construction. Then select the custom field for data import as dimension, property, and value changes, and import data for a second time.
Once custom field changes are imported, you can create calcuted measures with the custom field dimension and historical measures like “Days in transition”, “Transitions from issue count”, “Transition from first timestamp”, and others with the custom field dimension (see list and description of change history measures).
For example, use an expression similar to this to show the duration of the issue spent with the value Start.
(
[Measures].[Days in transition],
[Transition Field].[Custom field name],
[Cudtom field name].[Start]
)
More details on calcauted measures and tuple expressions are here: Calculated measures.