Option to transpose a Project Pivot matrix

[Former user]

Hello! Now Project Pivot has rows as projects and column as users. There are situations when it is needed vice versa - rows as users, columns as projects. It is needed as an option in a gadget configuration window.

[Andriy Zhdanov]

Hi Vitaly,

I should admit it's not feasible to do. But would like to know what is the reason? May be I can suggest some workaround.

[Former user]

Hello! The enquiry is I carry out an accounting in 2 dimensions: per projects and per employees (that are JIRA users). And for project accounting it is more applicable to set projects in rows. For employee accounting it is more applicable to set users in rows. So I need something like ProjectPivot both current view and transposed view. May be you can create another one gadget like current Project Pivot, but transposed.

[Julien Fritsch]

Indeed, this is needed, since when you have many names, it's inconvenient.

[Andriy Zhdanov]

Hi,

Here is what I've got so far:

Could this solve the problem for anybody?

Comments appreciated.

Thank you.

[Julien Fritsch]

This looks good to me.

[Andriy Zhdanov]

Version 2.10 for Jira 5-6 and 3.1 for Jira 7 with new Timespent Report is released.

[Julien Fritsch]

I found a little issue with it. It's possible to group the data by "worked user" indeed but only after the grouping per project. And this is not convenient when users do indeed work on multiple projects. I would rather see the grouping to be done by the single dimension asked in the config.

[Andriy Zhdanov]

Hi Julien,

It's just necessary to enable Collapse Field Groups report configuration option.

Thank you.

[Julien Fritsch]

Indeed. Sorry about that. This is working. Thank you.

[Andriy Zhdanov]

No problem, glad it works, thank you!