Count number of tickets that was shifted from team A to other teams

Questions & Answers
1

Hi community,
I’m trying to get a statistics of tickets that were processed by my team and sent to other teams.
I have found some formulas in community pages but it’s not doing really what I expected :frowning:

COUNT(
Filter(
[Responsible Team].Members,
(
(
[Measures].[Transitions to],
[Transition Field].[Responsible team]) > 0
)
)
)

If someone did already something similar and can share with me some thoughts ?

2

Hi, @dnuptn

Welcom to the eazybi community.

Please consider updating the formula with Descendants (Descendants) , to iterate through the Responsible team dimension and look for transition:

Count(
  Filter(
    Descendants([Responsible team].CurrentMember, [Responsible team].[Responsible team]),
    (
      (
        [Measures].[Transitions to],
        [Transition Field].[Responsible team]
      ) > 0
    )
  )
)

Please share the report definition to the support@eazybi.com if this is not working for you.

Kindly,
Ilze