RELATED IDEAS
Cells in Pivot Reports should align, like a table
Using the "Show Cell Headers" option in a Pivot Report is a nice way to include additional feature details in the view. However, if the text wraps or if you have blank values, the features and their details will become misaligned, since the pivot cells are not built as a table. It just slaps horizontal lines between each value to build a quasi-table view, which is not effective and severely limits the usefulness of showing cell headers. Please update Pivot Reports to act more like tables and keep cell values aligned!
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +1
5
MERGED
3
MERGED
Allow Pivot Table Rows to remain aligned
Currently, when pivot reports generate with tags in their own column, then the rows between columns do not remain aligned.
It creates confusion on what tag is applicable to which item. In the attached example. There is no tag on the last item on ...
0
Future consideration
© 2024 Aha! Labs Inc.•All rights reserved
This is not an enhancement. This is a bug.
I am trying to create a pivot report almost identical to the one in the original post and still seeing the misalignment issue.
Curious if anyone has more details on Jerrold's comment below that "it appears that the report itself now formats correctly." Are you still setting up pivot using cells? Or is there a different way to do this to keep cells aligned?
Following up on this 2 years later, it appears that the report itself now formats correctly, however, when added to a dashboard, the formatting reverts to the original issue. Additionally, when adding the report to a Presentation, the format is also fixed - it seems this is only 'broken' when adding it to a dashboard. My position in the my post back in 2018 has not changed - this should be considered a defect, not an idea or an enhancement request. This is tabular data, and I believe it is reasonable to expect that tabular data is aligned. I'm attaching two images, one showing the formatting in a report (working), the other in a dashboard (broken).
I have also run into this, trying to create a detailed "above the line" report for our executive team. If it was possible to "force row height" or "create consistent rows" (like a table), that would address our need. Another options could be to provide options to "decorate" a list view report so that we could create the visual distinction. A standard list report doesn't provide the visual distinction possible with the pivot report. The pivot report enables better "chunking" of the data. I have considered using the card view on the features board, but we have projects that span workspaces.
The workaround will not work for us because we need to have the features and their status grouped by release date. How do I line it up in this case?
Thank you for the additional comment here. There is a workaround which will help to better align the report. Using the example attached to the idea, if you move the Feature to appear as a "Row" instead of a "Cell," this will align the data in the way that you would expect.
Quite honestly, I find it a bit disconcerting that this item has been open for over two years. In my opinion, this is not a feature request, this is a defect. When data in reports do not align, providing them to stakeholders only leads to confusion. In fact, when I provided my screenshot to support, the initial response what that they do align, but that "The last record in your screenshot has 4 tag values so that entire row is larger to accommodate the 4 values. " It wasn't until I provided a screenshot identical to the one on the OP that I was asked to upvote this feature request.