dnuptn
August 29, 2024, 7:52am
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
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 ?
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