Show issues which changed Issue Type

Hi,

Could you please help me to come up with a calculated measure which will give me a list of issues which changed their Issue Type. For example I would like to see the list of all Bugs which changed their issue type to Feedback or Support.

I am not interested how many times issue type has changed, I am just interested to see the sum of all Bugs (list of all Issue type “Bug”) which at some point changed their Issue Type to “Feedback” or “Support”.

Hi @Azalija

Welcome to the eazyBI community.

In this case, you could try creating a new calculated measure using the following measure:

Aggregate(
  {
    [Issue Type].[Feedback],
    [Issue Type].[Support]
  },
  (
  [Measures].[Transitions to],
  [Transition Field].[issuetype],
  [Time].Currenthierarchy.DefaultMember
  )
)

It would count the number of times issue was changed to Feedback or Support

Then you could select this measure in your report and filter the report by this measure.
(New calculated measure > 0 )

Also, you could select the “Issues type” measure and filter your report for bugs only
(Issue type = Bug)

After that, if necessary, you could click on the column for new measure and remove the column from the report. Filter should remain

Martins / eazyBI support

1 Like