Calculate the value changes of a custom field

Hi,

I’m quite new in eazy BI world and I would need some help.
We have different Teams on our Jira project. We use a custom field ’Country to make the difference across the teams and move the tickets easily. My goal is to count how many tickets are transferred from countries x,y,z to the central country a. I already added in the advanced settings the “import value changes`’ for the custom field but I’m not sure about the formula

Thank you in advance.

Dorina

Hi @Dorina_Ababii ,

To achieve this you can use the Transition field hidden dimension together with Transitions to or Transitions to issue count Measures. See more about these measures here Import issue change history - eazyBI for Jira.

(
  [Measures].[Transitions to issues count],
  [Transition Field].[Country]
)

This would give the total count of transitions to the specified dimension members. Here is an example with a custom field ‘T-shirt size’ I have imported changes to:

Lauma / support@eazybi.com

1 Like