Skip to Main Content
Status Unlikely to implement
Categories Reports
Created by Nick Mariette
Created on Aug 9, 2017

Arbitrary sorting in reports, using values of data in row or column headers

It is awesome to see greater sorting features released (e.g. Thank you.

Unfortunately that update doesn't solve one of my sorting needs. I have a timeline report, in which I visualise release names and release dates for several releases of several products from several product lines simultaneously. It is quite a neat report, and one that gets used in high-level monthly reports. The only problem is that I can't sort the rows (with row headers showing product line and product names) in the way I need. On this report, some of my product lines are internal products that are dependencies of some other external products. I would like to put the rows with internal product lines at the top of my report, so the dependencies flow downwards. Unfortunately if the product line names were 'A', 'B', 'C', it turns out 'B' is the internal line. So there's no way I can sort (ascending or descending) to get the row for 'B' at the top of the report. What I need is arbitrary sort order (e.g. using those little grab bars that look like hamburger menus). Even if I were to make a custom field that creates the order I wanted, in other reports I might want to display using another apparently arbitrary order (that makes sense to me). Please add an arbitrary sort order in the report view itself.

    Aug 15, 2017

    Thank you for the idea. The sorting capabilities on pivot tables and custom roadmaps are field-based to make sorting longer reports simpler. There is a trade-off that arbitrary sorting is not possible. We would suggest adding a custom field to identify the internal vs external products. You can then use that custom field for sorting your report as needed.

    Due to the advantages with field-based sorting and the workaround noted above, we are unlikely to implement this idea. We hope you can understand.

  • Attach files

Allow me to custom sort columns/rows in pivot table

Right now, I can only sort columns in ascending/descending alphabetical order. I'd like to arrange the columns in a custom order.
Guest almost 6 years ago in Reports 0 Unlikely to implement

Manual Sorting in Pivot Table

Pivot tables in Excel offer the sorting option 'Manual (you can drag items to rearrange them)' would be great if that very same functionality would be available in Aha as well i.e. to control the order in which a roadmap is presented
Markus Gujer almost 6 years ago in Reports 0 Unlikely to implement