How calculate ratio based on two tables that can't be joined

Hi,

I am trying to compute a ratio based on values of two distinct tables which can’t be joined. Is there a way to do this ? I was thinking that maybe it was possible to create 2 different questions which both output a number e.g. question1 = 2 and question2 = 4 and then do a third question which is equal to the ratio of the two first ones i.e. question1 / question2 = 50%.

Is there a way to do that in Metabase ?

Thank you very much in advance !

Hi @anton1
Sounds like Sub-Query would be a solution for that:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#using-an-existing-question-as-a-sub-query

Depending on how you intended to implement what you’re asking for, it sounds like this request would make it possible to do what you’re asking for too:
https://github.com/metabase/metabase/issues/10273 - upvote by clicking :+1: on the first post

Hi flamber,

Thank you very much for your response. And is there a way to apply a filter in the sub-query ? In fact, I would like to implement a date filter on question 1 (from the example in my first post). Is there a way to this ?

Many thanks

@anton1 Not officially, but read the comments for a hacky workaround:
https://github.com/metabase/metabase/issues/6449 - upvote by clicking :+1: on the first post