Calculate the number of tickets having had a change in value on a custom field

Hello EveryBody,
I would like to calculate the number of tickets that have gone from a PI20 field to a PI21 field For this I have used the formula below to create a new measurement except that it does not give me anything

Sum(
 Filter(
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[issue]),
   
  
  ([Measures].[Transitions from],
   [Transition Field].[PI],
   [PI].[PI 20])>0
 AND
  ([Measures].[Transitions to],
   [Transition Field].[PI],
   [PI].[PI 21])>0

   ),
1
)

Thanks you for help.

Hi @mehdi_HACHIMI,

A warm welcome to the eazyBI community :sunny: !

The formula you shared should work. Although there are several pre-conditions:

  1. The field “PI” is a single-value field
  2. You have enabled the change history import for this field
  3. The PI dimension member names PI 20 and PI 21 are referenced correctly

Please verify that the custom field “PI” is imported with the “Import value change” option. If not, please, check whether the field is a single-value field. eazyBI can import value change history only for single-value fields. If “PI” is such a field, follow the steps described here - Import issue change history.

Let me know if you have any questions.
Best,

Roberts // support@eazybi.com

1 Like