Metrics Row Re-odering

[jane_120]

Hello everyone,

I have used a freeform table in Analytics Workspace.

I wish to re-order the metrics row. Is there any way/method that it can be done?

[leocwlau · Accepted solution]

In freeform table, rows can only be sorted by clicking the up/down arrow on any one of the columns or the component header.

[jane_120]

Yes, I'm aware of the sorting of rows but I want to re-order the metrics.

I went through this video Reordering Static Rows in Analysis Workspace | Adobe Analytics too but didn't help.

[leocwlau]

You need to enable "Enable table builder" before dragging any components into the freeform table.

[Jennifer_Dungan]

Well that is assuming they used "Table Builder"... I don't... 

If you are not using Report Builder, you can sort the metrics alphabetically (there is a sort option in Metrics)

and

Table Builder does allow you to order the metrics as you want, but then you have the limitations of Table Builder (which may not apply to you).

IF you don't want to use Table Builder, you can do a little hack, and recreate all the metrics as adhoc calculated metrics, and add "1. " and "2. ", etc to the names, then sort alphabetically.... You will actually see "1. 1. Metric X" in your row though.. but this was the pre-table builder solution we used to use.

Most of the time, I don't use Metrics as rows (since I can't create calculated metrics from selecting two metrics), but I do see the need for this type of display.

Good luck.

[jane_120]

Thanks, @Jennifer_Dungan this is informative!

I too usually don't use metrics as rows but needed it for a particular client request, but unable to re-order it, though I dropped in the metrics in the order in which I needed them.

[Jennifer_Dungan]

I understand! And you're right, sometimes it's unavoidable.

[jane_120]

okay but how do we enable 'Table Builder'?

[leocwlau]

In an empty freeform table, there is a button to enable the table builder. You can't enable table builder after dragging any component to the freeform table.

[jane_120]

Ohh yes..how did I not see that!

Thank you so much @leocwlau !

[Jennifer_Dungan]

One important detail of user Table Builder.... IF you make any changes to the table in the normal drag and drop mode, they will all be lost when you reopen the table in Table Builder (as in, all changes revert to the initial Table Builder design)

So if you need to make updates to the table, it's highly recommended you open Table Builder and make the changes there each time.