How to sum a field grouped by Team and filter by Time?

[Kananda_S_Silveira]

Hello guys, I am trying to sum a jira issue field (Zendesk Ticket Count) group by Team and filtered by Time.

I have created this calculated measure “Total de tickets”>
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Team].CurrentHierarchyMember.Name = [Issue].CurrentHierarchyMember.Get(‘Team’)
),
[Issue].CurrentMember.Get(‘Zendesk Ticket Count’)
)

And a tuple measure “Total de chamados”>
([Measures].[Issues created count],
[Issue Type].[Chamado]
)

When filter my report by Year 2023 the “Total de chamados” measure is recalculated but my measure “Total de tickets” don’t (is it sum all the chamados for all times).

How do I make this field respect the filter Time? Thanks

[ilze.leite]

Hi @Kananda_S_Silveira

You may want to import custom field “Zendesk Ticket Count” as a measure: Data from Jira. After data import, you would have a set of measures related to this field. Then, instead of “Total de tickets”, use predefined “Zendesk Ticket Count created” measure to count the total of tickets from all issues created in the selected time period (this measure is related to issue creation date when you select Time in the report).

Best,
Ilze LA, support@eazybi.com