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
)
))