How to retrieve and count values from a Multi-select field that is cleared upon Resolution?

Questions & Answers
1

Hi everyone,

I’m facing a challenge with a custom Multi-select field in Jira Cloud.

The Scenario: Due to our workflow configuration, the values in this Multi-select field are automatically cleared (set to null) when a transition sets a Resolution.

The Goal: I need to create a report that:

  1. Retrieves all values of this field for each issue before they were cleared.

  2. Displays these values in a report.

  3. Allows me to count occurrences of these values across multiple issues.

What I’ve tried: I enabled “Import value changes” for this specific custom field in the import settings. However, when I use the dimension in my report, it still shows as (none) because the current state of the issue is empty.

My Questions:

  • Is there a way to “capture” the last non-empty value from the change history using MDX?

  • Should I be looking into a JavaScript Calculated Custom Field to persist the last known value during import?

  • What would be the most efficient way to ensure I can still use these values as a dimension for filtering and counting?

I would appreciate any guidance or examples of Calculated Members that could solve this “cleared on resolution” data loss.

Thanks in advance!