Derived row and column categories please

[Douglas Swartz]

Xavier, You responded so quickly on my "fancy cell calculation request", that now I've come up with even more uses for the Pivot Table.

See the screen shot of a Pivot table made from a Jira Issues macro. It works great, except, that no-one wants to look at those Jira User IDs. They want to see the user's real name.

If the Pivot Table macro had a row and column category transformation macro similar to the cell calculation one, that would be marvelous! I can't do this kind of transformation with your nifty regular expression logic.

Doug

Also, Do you accept submissions to the project on Bitbucket? I don't get a lot of time to write code anymore, but this is the kind of project I might like to contribute to now and then.

[Xavier Arques]

Doug,

First, thanks for your nice user review.

Regarding your proposal, I have some questions:

1. Which field do you query from Jira Issues macro that returns Jira User Ids ? I tried with assignee and reporter and it returns the full name of each user, not their ids (see snapshot below)
2. In your example, would you like to transform AMBM01, CRUM01, ... to readable user names and define this transformation inside a regexp ?
3. It's the first time someone asks for submissions to my project and I appreciate it. I can add you as contributor if you want. I need to define some rules especially on tests purpose. I provide unit tests and functional tests for each new feature I develop and I expect you to do the same :) . I also plan to refactor the way pivot values are calculated. The code became more and more complex and I need to simplify it.

Xavier

[Douglas Swartz]

Xavier, 1. It's a custom user picker field. I have no idea why it returns the ID rather than the user name. 2. The Jira example was just one example. Yes. I want to transform the user ID to a readable user name. But, while possible with a regexp, that feels like a maintenance nightmare.

[Xavier Arques]

Doug,

I'm working on refactoring that will allow to define a replacement string for one or more pivot values. This enhancement could be used to group pivot columns (For example, groups values 'New' OR 'To Do' in the same columns named 'TO DO', using regex like New|To Do) But I agree with you that for replacing Jira User Id, it is not the right approach. If it is a custom field, can't you changed it into Jira to provide readable names ?

[Douglas Swartz]

Here's another example of how I need to manipulate the row or column headings: I've got this beautiful pivot table (which used a custom calculation :)). To make the application user friendly, I need the row labels to be links to another page using the value of the row as a URL argument for that page.

Is there a way to do that with the current version of Pivot Table?

[Xavier Arques]

Doug,

If you want to hyperlink the columns and rows pivot headers ("Auditing", "Authentication", ...), no it is not possible. I should provide an extension of Pivot Rendering Values to Columns and Rows headers.

But if you want to hyperlink the icons in each cell, it should be possible by adding the HTML macro with an anchor in the pivot-values-rendering user macro

[Douglas Swartz]

Yep. What I want to do is hyperlink from the row title (Confluence, Joes test,...).

I can't link off each icon, because only the calculated cell data is passed to the pivot-values-rendering macro. To build the URL, I need the title text available.

Thanks. Doug

[Xavier Arques]

Start refactoring of PivotTable to allow full customization of Pivot Table Rendering using a user macro