Selecting the max/latest value from a query based dropdown list

Support
1

Is it possible to have the query based dropdown list automatically select the max or latest value?
My code is:
select count( distinct users) from raffle where raffle_event = ‘ticket_purchased’ and raffle_id = {{Raffle ID}}
where Raffle ID’s are numbers.
The query for raffle ID’s is:
select distinct raffle_id from raffle where raffle_event like ‘%Raffle_s%’ order by raffle_id asc
The raffle ID’s go from 1 to 20, once raffle 21 is created I would like the dropdown to automatically select raffle 21 as the default query on my dashboard, if it is possible

2

This isn’t supported.

3

I see, thank you for the reply.