Salse Portion

nurit.a · August 5, 2020, 5:40pm

Hey
I want to calculate "Salse Portion":
Capture
How do you do that?!

flamber · August 5, 2020, 5:47pm

Hi @nurit.a
It sounds like you’re looking for Custom Expressions:
https://www.metabase.com/blog/custom-expressions/index.html

nurit.a · August 5, 2020, 6:02pm

@flamber tnx
but i am looking for a SQL function for this problem

flamber · August 5, 2020, 6:19pm

@nurit.a Okay, then go to stackoverflow.com and try to find SQL for the database type you’re using.

nurit.a · August 10, 2020, 10:20am

This is the way to the solution:
SELECT SUM(netIncome) AS 'net ’
,net/ ( SELECT sum(netIncome) from ALLOrders ) as “percent to total”
,category
from ALLOrders
group by category