Dividing column values by total

Get Help
1

We have data of item quantities that fall into several categories.
We need to calculate, for each category, the sum of quantities divided by the entire ungrouped sum of the column.
Is this doable with the GUI question builder at all?

2

Hi @DreamDweller
Currently not, you would have to do it in SQL - example on how to get ration with Sample Dataset:

SELECT
    category AS "Category"
  , COUNT(*) AS "Count"
  , ( COUNT(*)::FLOAT / (SELECT COUNT(*)::FLOAT FROM products) ) AS "Ratio %"
FROM products
GROUP BY category

You are likely looking for this request:
https://github.com/metabase/metabase/issues/12017 - upvote by clicking :+1: on the first post