Calculation on aggregate

Get Help
1

Hello,

I need to calculate a rate, how can I do it with the query builder ?

The SQL query would be :

SELECT ALL SUM(percent_value = 1) / COUNT(*)
FROM my_table

Thx,

2

Hi @sfa
Looks like you're searching for Custom Expression SumIf([percent_value] = 1) / Count
https://www.metabase.com/learn/questions/custom-expressions

3

Great :+1:

I discover Share() function too ( https://www.metabase.com/docs/v0.41/users-guide/expressions-list.html#share )

Thx !