How do I create a Daily TopN Custom question

Get Help
1

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?

2

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.

3

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.

q1
q11910×790 68.9 KB
q2

4

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