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%.
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 on the first post
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 ?