Count Transition to Custom Field per Assignee by Month

Questions & Answers
1

Hi all, We have a custom Jira field called “Flagged Options”. Looking to create a report that counts how many time the state of the “Flagged Options” field transitions to “Pending Further Development” state per “Assignee” by month. The “Flagged Options” field was imported as a dimension and property with a data type as a “string”.

Current report only counts the “Flagged Options” field when the current state is “Pending Further Development”. I need the history of each time the filed transitioned to the state and not just the current value. I need something like the screenshot provided.

I think what I need to do is “Define new calculated member”. I tried reading the documentation and I think I am missing something as I can’t figure out how to do this. Any help would appreciated :slight_smile:

flaggedOptionsReport
flaggedOptionsReport1764×2400 83.9 KB

2

Hi all, I got the following feedback from the support team which worked out great.

First step was to change the was the field was imported:
(1a) Add the following lines to “Additional advanced setting”

separate_table = true
changes = true

(1b) Save advanced settings, and the “Import value changes” checkbox will become available.
Check it and run the import.

Then to create the new calculated measure:

**- "Transitions to Flaged Options"** - to count all transitions to any Flaged Options value

([Measures].[Transitions to]
,[Transition Field].[Flagged Options])

Once that was done, I need to filter the data in the table to only display the “Pending Further Development” transition count.

Hope this helps :slight_smile: