How to count number of issues that exist which have text in a property field?

I have created a rich text field in my jira instance to contain example mapping artifacts for stories.

I would like to make a trend chart that shows how many jira issues have any text in that field, in other words “NOT isEmpty()” I think.

How would I create a measure to do this? It’s not how many issues were created like that, or resolved, or are currently unresolved - just how many exist in the jira instance. The resulting chart would be constantly increasing to various degrees. I think my problem is identifying a measure to add context to the report. I say that because of this similar solution that yet is not helping me: How to find the count of issues with EMPTY Case Numbers and NON EMPTY Case Numbers

Hi @kevinwhite-verint ,
Can you please share the measure you have created based on that community article?
Your measure should look like this. Measure “Issues created” is needed to define that the issue exists, if it has a creation date, it has been created:

NonZero(
  Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
     NOT IsEmpty([Measures].[Issue YOUR TEXT FIELD PROPERTY] AND
      --measure to add context of the report
      [Measures].[Issues created] > 0 )
    )  
  )
)

See more details in my colleague Zane answer here:

Kind regards,
Gerda

Hi @gerda.zandersone Here is my measure:

NonZero(
  Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
      NOT IsEmpty([Measures].[Issue Example Map]) AND
      --measure to add context of the report
      [Measures].[Issues created] > 0 )
    )  
  )
)

However, the difficulty is that I added this field recently in late October or early November, and yet it will show issues on a trend chart back when they were really created. I don’t need to see issues created over time that have this field not null; I need to see the number of issues with this field not null at each member of the time series. I hope that makes sense.

@kevinwhite-verint ,
Do you mean like cumulative sum? That the measure should count all issues created from the first day till today?
For that, you can explore standard calculation - Cumulative sum on top of the created measure.

Kind regards,
Gerda