SELECT(SELECT count(b.id)
from
bookings b
join
booking_ratings_users r
on
b.id = r.booking_id
where (b.status = 'collect_payment'
and r.rating in(4,5)
and {{created_at}}))
/
(SELECT count(id)
from bookings
where status in('cancel_admin','collect_payment','cancel_client')
and {{created_at}});
Hi @Mohammad_Abdallah
Read this: https://www.metabase.com/learn/sql-questions/field-filters#field-filters-are-incompatible-with-aliasing
Many thanks!
It worked 