Determine change in state of Jira free text field

I am creating Jira quality management reports to determine if free text fields are following the guidance provided by the programme. For example, with a Jira summary we are looking for certain key words in the summary that are not meant to be included and want to track if these numbers are reduced over a period of time.

I have created some advanced settings to pull in the free text fields as measures and as value changes. I’ve also created some measures to identify the tickets with the key word in the summary - this works and updates as the summary is updated but doesn’t show the historical figure when using the time dimension in rows i.e. it shows the summary was updated on the date of creation.

The measures I have tried are here:

Measure 1:
NonZero(Count(
Filter(
DescendantsSet([Issue].Members,[Issue].[Issue]),
NOT IsEmpty([Measures].[Issue Summary]) AND
(
Len(CoalesceEmpty([Measures].[Issue Summary],“”))
- Len(
Replace(CoalesceEmpty([Measures].[Issue Summary],“”), “SUMMARY KEY WORD”, ‘’)
)
) AND
[Measures].[Issues history] > 0
)
))

Measure 2:
NonZero(Count(
Filter(
DescendantsSet([Issue].Members,[Issue].[Issue]),
NOT IsEmpty([Measures].[Issue Summary]) AND
CoalesceEmpty([Measures].[Issue Summary],“”)
MATCHES “SUMMARY KEY WORD” AND
[Measures].[Issues history] > 0
)
))

Hi @CMCK
Welcome to the eazyBI community.

eazyBI won’t let you import change history for any free text field.
If the field is redefined with data_type = string from advanced settings, you could try import it as dimension with value change history but this would work only for single-select custom fields.

For fields imported using Javascript in advanced settings or Jira scripted fields, it won’t be possible to have a history imported in eazyBI.

Martins / eazyBI