Join us January 15th for an AMA with Champion Achaia Walton, who will be talking about her article on Event-Based Reporting and Measuring Content Groups!
It would be great if the option to manually select the ordering of the row dimensions were available, i.e. dragging and dropping where should go, just as we're able to do with the column dimensions - currently there is only the option of ascending or descending order.
In terms of ordering of the columns it would also be useful to have the option of sorting the labels in ascending and descending order.
Thanks for all this great feedback - we have manual row ordering on our backlog and are actively looking into a solution. I'd like to make sure I have the primary uses cases articulated so we can make sure we address them. Are they:
1) Ability to order metric rows manually, e.g. so you could show clicks, orders, then CVR in that order.
2) Ability to order numeric dimensions manually - for this one, we may not be able to let you click "sort in numerical order" because we store dimensions as text at this time (this hits another effort we are pursuing though), but would just the ability to drag & rearrange suffice in the meantime?
For #2, it would get rather tedious if we have many dimension values, but in general, manual reordering would be a decent stopgap for many of our problems.
The manual reordering would need to be able to be "locked" once we set the order, because it seems like often the items get reordered if the data gets re-ranked when it is refreshed.
I'm going to keep hinting until maybe it gets implemented: Can we just have a table builder in Ad Hoc? Please?
Exactly! This can be done in Ad Hoc and Report Builder (preserve order) - I assumed I just didn't know how to do it in Workspace. But this is a MUST! Example, I have a time parting hour variable and would like those to appear in the order they occur (12, 1, 2, 3, etc) and not sorted by which has more visits/activity.
Being able to set the order, preserve or lock the order, drag and drop- all that.
Was option 2 solved? It'd be great to manually order some dimensions so that they are always in the same order, no matter if visit sorting would be them in a different order.
Option #2 can be achieve through manual reordering, but a "sort on numeric text" option is still not possible. We treat numeric IDs as text, not numbers, so it will take a bit more work to allow for that.
Since manual ordering has been marked as Delivered, please open a new thread for numeric text sorting if that is an improvement you would still like to see. Thanks!
@Jen - I already had a table built and now want to reorder. The drag-and-drop option as shown in the video seems to only work for me when creating a new table from scratch. How to reorder the rows in an existing table?
