Filtering by team members

[r.gamma]

Hi
We are using eaziBI since some time now and are quite happy.
For some reports we would like to analyse logged time for users which are part of a team.

So far I see in eaziBI the team is only imported as custom field, which means all logged time on a jira issue on which the team is set.
The teams as teams are not imported similar to groups to use it like “logged by group”.
I see we could use the teams api to get the teams, but to get the members of the teams it would require follow-up calls, which I don’t see as possible right now.

Just figured out, that with teams graphql the teams including members could be queried.

query allTeamsWithMembers {
  team @optIn(to: "Team-search-v2") {
    teamSearchV2(
      organizationId: "ari:cloud:platform::org/aaa-bbb-ccc"
      siteId: "ddd-eee-fff"
    ) {
      pageInfo {
        hasNextPage
      }
      nodes {
        team {
          displayName
          members {
            nodes {
              member {
                name
                accountId
}}}}}}}}

Is there a way to achieve this?
Could this be done by importing the teams with graphql and filter it similar to logged by groups?

Regards,
Ramon

[ilze.krauze]

Hi r.gamma,
Welcome to the eazyBI community!

If I understand correctly which Team field you mean, here are a few steps you could try:
(1) In the Jira import options, Custom fields tab, search for field “Team” and select it for import.

(2) After the import you can use both dimensions in your report

This method does not create a hierarchy, but it achieves a similar result, allowing to filter by team and have subtotals by teams.

I hope this helps!

Best,
Ilze

[r.gamma]

Hi @ilze.krauze
Thanks a lot for your response and the proposal.
I also used this, but with that there list shows logged hours by users on issues with team assignment.

What I like to achieve is logged hours by members of a team on all possible issues.
This is a different view on the logged hours.
Because of that there is the need of “Logged by Team Members” similiar to “Logged by group”.
With the import of the teams from the API this could be done…