How do I create a Daily TopN Custom question

Version 0.38.1
When I implemented a daily TopN requirement, I found that our users did not use SQL.
I didn't find a way to do that when I tried to create a Custom question.
Can someone give me some hints?

Hi @zhaoqing
Please post "Diagnostic Info" from Admin > Troubleshooting.
I'm not sure I understand what you're asking. Currently Metabase does only support Limit on the final results in the GUI, so I think you need to create such questions in SQL, but it would be helpful if you posted the query, so we have a better understanding of what you're trying to do.

I'm sorry that my description has troubled you.
I created a question with Native query, and now I want to implement it in the way of Custom question, but I have tried many times but failed.


Post "Diagnostic Info" from Admin > Troubleshooting.
I don't understand - what is failing?