Hello @Micha Roon !
As I understand, you need to sort the order of items within your Page Properties Report macro based on the contents of the Status column.
The problem we are facing here is that we are trying to order a macro, which is not a “raw” value for the editor or the Page Properties Report Macro.
I tried to order the values based solely on the macro but was also unable to. My workaround was to add a value right beside the Status Macros of my pages with the Page Properties macros. Like this:
When I did that, all pages were ordered as expected. Here is how it looks like:
I hope this helps you out, Micha! Looking forward to your reply.
hi @Diego I'd like to follow on to this, if I may. My team is similarly using macros and we'd like to sort too. We have tried to put in a leading number to get the sorting to work instead of a letter. I've tried a few different forms/formats for this to no avail.
Here's what I'm getting sorting on "Numerical" via the macro Sort settings - no idea what it's doing (sorting on the alpha num and priority fields yield similarly illogical results):
The more annoying part is, somewhere in there, it knows how to sort this data by the status macro label value. If I manually click on any of the column headings for Alpha Num, Numerical, or Priority, data is ordered the way that I would expect:
How can I configure my Page Properties report Sort settings to achieve this? I've tried all manner of adding/excluding asc/desc to the Sort parameter, in conjunction (and not) with the "Reverse Sort" option - nothing works. Any ideas?
Hi @Katerina Kovriga _Stiltsoft_
I see that - thanks for pointing that out. What do you make of the manual column sorting getting those labels into the order I'd expect without needing to do anything additional to the data in those fields? Any plans to expose whatever metadata option it's reading from to users so that we could set that same sort parameter by default?
The status macro is handy and useful for visually grouping items, but that depends on the ability to sort as one would expect.
I can suggest trying our app - Table Filter and Charts for Confluence (it is a paid add-on). Maybe you've already been using it for your Confluence - it works with the Page Properties Report macro perfectly well.
Here are even more dashboards based on the app and the Page Properties Report macro.
We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...