Column orders changing in Analytics Workspace over time

Learn why the column order keeps changing in Analytics Workspace.

Description description

Environment

  • Customer Journey Analytics
  • Adobe Analytics

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:

Monday
Tuesday
Wednesday
Thursday
Friday
Hour of Day
7357
7491
7933
7695
10434
8:00 AM
3714
3802
4003
4003
4349
9:00 AM
4235
4332
4560
4487
4694
10:00 AM
3732
3678
4180
3880
4211
11:00 AM
3566
3402
3873
3860
4957
12:00 PM
2888
2884
3274
3131
4025
1:00 PM
2246
2276
2609
2316
2431
2:00 PM
3182
3294
4946
3439
2115
3:00 PM
3187
3245
4165
3428
1742
4:00 PM
2892
3113
3867
3216
1374
5:00 PM
2216
2213
2815
2444
1000

May appear as below after some time:

Monday
Tuesday
Wednesday
Thursday
Thursday
Hour of Day
7357
7491
7933
7695
10434
8:00 AM
3714
3802
4003
4003
4349
9:00 AM
4235
4332
4560
4487
4694
10:00 AM
3732
3678
4180
3880
4211
11:00 AM
3566
3402
3873
3860
4957
12:00 PM
2888
2884
3274
3131
4025
1:00 PM
2246
2276
2609
2316
2431
2:00 PM
3182
3294
4946
3439
2115
3:00 PM
3187
3245
4165
3428
1742
4:00 PM
2892
3113
3867
3216
1374
5:00 PM
2216
2213
2815
2444
1000

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.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f