How to automatically select the first row of a BAQ when refreshing

I created a dashboard with few BAQs. I have a BAQ that is filtered by date and automatically refreshed by another BAQ from a published data.

I would like to automatically select the first row of this BAQ when it refreshes instead of a random one. How can I make it works?


I would like to know the answer myself, but I know a way around this.

Your problem is that your sort is not done in the BAQ. When you sort after that, in the dashboard, it keeps the selection on the row that was first before the dashboard sort.

I find this annoying, but I know now that I have to plan ahead with sorting.