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
With the automated report I get this ordering

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?