Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Locking row order

oodaddy2
Level 2
Level 2

I have a report that has several time dimensions, among them are today and yesterday. The report is run automatically at midnight to catch the days totals. A summary number widget catches the visits for today, a summary change widget looks at the change from yesterday to today.

When I run the report manually I see this ordering

1748781_pastedImage_0.png

With the automated report I get this ordering

1748782_pastedImage_1.png

This causes the widgets to show yesterdays visits, and the difference from today to yesterday.

How can I lock the row position to ensure this doesn't happen?

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

it is not possible to "lock" a certain order. either sort by the metric "visit" or the dimension "time".

if you want to keep a certain order for the line items, there is a little trick: give your items a name that allows for the right "asc" or "desc" order, eg. start the names by a), b), c) or I, II, III, ...

View solution in original post

3 Replies
ShamshulA
Employee
Employee

Log a ticket to clientcare@adobe.com that they can try to replicate this by sending automated report to their email ID.

jantzen_belliston-Adobe
Community Manager
Community Manager

Hi Mark,

Did you end up finding a solution to this problem? If so, would you mind sharing it here incase others have this same issue?

Thanks,
Jantzen

ursboller
Correct answer by
Community Advisor
Community Advisor

it is not possible to "lock" a certain order. either sort by the metric "visit" or the dimension "time".

if you want to keep a certain order for the line items, there is a little trick: give your items a name that allows for the right "asc" or "desc" order, eg. start the names by a), b), c) or I, II, III, ...

View solution in original post