How to do count of rows in a column divided by count of rows in another column

1

So i am using the metabase query builder(UI interface) without wanting to write an SQL statement. How do i create a custom function to do a count of column 1 / count column 2

2

Hi @Tobiodelola
Welcome to Metabase!

From what I can infer you want to divide the count of 2 different columns.

Since the table contains same amount of data, this will give you 1 which I don't think is what you want.

Also the custom expression in Metabase doesn't allow user to count by specific column.

Perhaps, you want to count by a given condition?