Aggregate Tempo Teams members

Questions & Answers
1

Hi,

I would like to generate a filter with all members from a specific Tempo Team with the same behaviour as a basic aggregate but want to auto-populate its content with the team members.

So instead of doing it manually :

Aggregate({
  [Logged by].[User1],
  [Logged by].[User2],
  [Logged by].[User3],
  [Logged by].[UserX]
})

Would like to have :

Aggregate({
  [Logged by]."Tempo team members"
})
2

Hi @Guillaume_Lorquet

Sure thing!

You can map the Team as a property for each user and then create a new Team hierarchy in the Logged By dimension.

To do this, you will need a document with a list of team members in one column and their respective team in another column.
You can check out this Community post to see the step-by-step guide on how to map “Squad” property to the Assignee dimension: How to create a Team of assignees - #6 by zane.baranovska

You can apply the same steps in your case for the Teams for Logged By dimension.

Let me know if you need any additional assistance with this!
Best regards,
Nauris / eazyBI support