Grouping by team according to worklogs

[Lukáš Kuthan]

I have a structure with this hierarchy:

Initiative 1

   Epic 1

   Epic 2

Initiative 2

...

I want to get hierarchy like this (with also worklogs column of given team summed from epics to initiative to team):

Team1

   Initiative1

      Epic 1

      Epic 2

Team2

   Initiative1

      Epic 1

Team3

   Initiative 2

      Epic1

...

We are using Structure for Data Centers version 9.2. We have all worklogs time-sheeted on Epic level (we use Tempo timesheet plugin). All people from IT do timesheets. On organizational level, we have IT department which splits to IT groups which splits to IT teams (I want to see only worklogs of one IT group with all its IT teams).

I think I can't mix static (pass values from formula) JQL (worklogAuthor in team (X)) with dynamic cycling through different worklog users, that I work with by filter in formula, so the only possibility that I had was defining ARRAY (user1, user2, user3) for each IT team and also MERGE_ARRAYS(team1, team2,...) for IT group, that I am interested in (to avoid users from other IT groups/teams). 

I think I can start with something like (I planned to use it in Group by --> Attribute... --> Formula):

worklogs

   .GROUP (IF(INDEX_OF(team1,$.author)>=0;"team1"))   //I can't make up correct syntax to check author against several teams and sum up its timeSpent by the given team... I think I must create an Array like (team1(user1, timeSpent1), team2(user2, timeSpent2,user3, timeSpent3)) and then try to group by that...

end of "must" requirement

----------------------

Nice to have requirement:

If it is possible to get hierarchy like (have users with their worklogs on given epic as next hierarchy level):

Team1

   Initiative1

      Epic 1

         User1

         User2

      Epic 2

         User1

I think it is not possible (I can only "group" by worklogs on epic and not "split" by worklogs on epic, but maybe I am wrong. I would appreciate any kind of help. I know about possibilites of Tempo reports (but it has its limitations), and also possibility to save "team" on issue after user do some worklog, but we can't use it. All magic should be done by structure and formulas :)

[Stepan Kholodov _Tempo_]

Hello @Lukáš Kuthan 

To group issues by their worklogs' authors and mapping certain authors into certain teams at the same time, you can use a formula like this:

with team1 = if worklogs.filter($.author = "user1"): "team 1":
with team2 = if worklogs.filter($.author = "user2"): "team 2":
split(array(team1,team2), ",")

I hope this helps. If you need further assistance with this formula or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Lukáš Kuthan]

Hello @Stepan Kholodov _Tempo_ , it works! :) thx a lot

how about the "nice to have requirement" about having worklogs of users from given team splitted under each epic? - is it somehow possible? It would be pretty nice new type of generator "Split" for people who goes top-down and not always bottom-up...

[Stepan Kholodov _Tempo_]

@Lukáš Kuthan 

It's not possible to add a group underneath an issue; groups are always above issues because groupers 'look down' when they extract data. Adding a group below an issue would require significant reworking of the Structure's architecture, and there are no such plans at this time.

Best regards,
Stepan