Limit Dashboard filter

1

I have done a question using metabase query builder now i have defaulted the row limit to 10
Is there a way to add a dashboard filter so that i can dynamically change the limit.

2

You'll need to convert the question to SQL, then add a variable to the question:
image

That's Postgres syntax. If you're using MS SQL, it would be TOP after SELECT.

3

That i know. Can we do it in metabase query builder which will be any value based on the input value.

4

I don't think so. I tried to create a rank formula using Offset but couldn't make it stick. I tried cumulativeSum too, no joy.