is there somewhere it explained how to use aggregation functions with the case statement other than the documentation because I didn't really find it useful for my case
I would strongly recommend you do a database view and then use a simple aggregation in a table (a database view is seen like a table in Metabase)
1 Like