Column orders changing in Analytics Workspace over time

Learn why the column order keeps changing in the Analytics Workspace.

Description description

Environment

Issue/Symptoms

It has been reported that sometimes changes in the column order of heat map reports peculiarly over time, automatically.

So, a table which was set initially as below:

May appear as below after some time:

Resolution resolution

By default, in Workspace, when you bring in a dimension to the columns (like Day of Week here), it explodes into the top 5 dynamic items for that dimension. If you do not want them to change with time, you need to right-click on them and select Make item static.

You can confirm if the items are static by hovering over them - there will be a lock icon that appears. That means the item is static and won’t change with time.