I have a problem where I need to see count of Pod Members since I am managing 5 different teams.
I tried Count ([Assignee].members) but it is not grouping it on the basis of POD and give a combine count
even Aggregate is not providing the desired result.
Team Count of Team members
Team A 9
Team B 7
Team C 6
Team D 10
Team E 5
Welcome to the Community!
First, to group your Assignees by Teams, please check out this guide by Zane: How to create a Team of assignees - #6 by zane.baranovska
When you’ve imported the Team property for Assignees and added the Team hierarchy to the Assignee dimension, you can select the “Team” level members for your report and use it together with a new calculated measure in the Measures dimension with the following formula:
You should be able to achieve the following report that will count how many members each team has:
Let me know if this works as expected!
Nauris / eazyBI support