Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!
SOLVED

Locking row order

Avatar

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

Avatar

Correct answer by
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

Avatar

Employee

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

Avatar

Level 10

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

Avatar

Correct answer by
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, ...