Hi guys,
I am a new user to Metabase and so far I like it a lot.
But I am wondering if it is possible to do the following:
I am using a SQLite database, and there is a column in a table called recv
,
there is also a timestamp
field, and some other text-based fields.
What I would like to achieve is:
- either to include a new column in the table (raw data) that has a value of
sum(recv)
- or to include a new column in the table (raw data) that has a value of recv/sum(recv)
Even when I do a custom SQL expression like:
SELECT "peer_cc_stats"."recv"/sum("peer_cc_stats"."recv") AS "recv_ratio", ...
the result set for a weird reason is 1 row (?)
Could you please advise on how to achieve this ?