Count per user over time?

1

We are trying to show how many orders a user has over time.

Is there a way to divide two results in the visual editor? Right now I'm relying on a SQL statement to query for a count of orders, and a distinct count of users, then dividing the two.

Thanks!

2

Hi @boiserunner
Are you just looking for Custom Expressions or are you looking for windowing functions?
https://www.metabase.com/docs/latest/questions/query-builder/expressions
Include your SQL, then it makes it a little easier to understand if you can do it in the GUI.