Report to find issues with one custom field value to another
I have a single list custom field A which has 3 drop-down value 1, 2 and 3
i want the list of issues in a report which shows all issues in which A field value changed to 3 from other value.
Can you suggest how can we implement it
I think you could create the following Measure:
( [Measures].[Transitions to], [Transition Field].[Custom Field A] )
With this, I believe you could put the Issue Dimension in Rows and the new measure over custom field A value 3 both in Columns.
Have a good day
In eazyBI, you can import the change history of the single select custom fields.
First, make sure to import change history for custom field A.
Go to import options, tab Custom fields, and mark “Import value changes” for the custom field A and Import data. If you do not see this option “Import value changes”, you can enable it through eazyBI advanced settings. For more details, please see the documentation: Import issue change history - eazyBI for Jira.
In the report, you may define a calculated measure that would look at change history for Custom field A. For calculated measure, use measure “Transition” to in combination with dimension "Transition Field" as @Marilou already suggested.
If you like, you may even specify the custom field value you are interested in the calculation:
( [Measures].[Transitions to],
[Transition Field].[Custom Field A],
[Custom Field A].[value 3] )
Zane / support@eazyBI.com