Count ticket in specific issue type and status

sum([Measures].[Issues history], [Assignee].CurrentMember.Parent)

It should return all assignee 's tickets.
How should I specific it to Story and in Done status

Hi @wing

I recommend using eazyBI standard dimensions and measure in your use case.
You could add Status and Issue Type dimensions to Pages and filter on required values (“Done” and “Story”).

You could then add the Assignee dimension to Rows. It will summarize all tickets resolved (when selecting the measure “Issues Resolved”). You will be able to see all tickets resolved amongst all assignees, and additionally, you can expand “All Assignees”, allowing you to see the results per specific Assignees.

I recommend watching this training video, it is very useful when learning how to create reports - Training videos

Best wishes,

Elita from support@eazybi.com

1 Like