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
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?