Hi is there a way to create and display a value on a dashboard that is derived from two or more other questions? I have some questions that display single values that I’d like to sum and multiply together.
I guess I could create one mondo question through SQL but it would be messy/redundant to do so.
Ted
Hi @yangabanga
You would have to create another question, which uses the other questions to generate a final value.
is there a way to do that without duplicating the questions themselves literally in sql? as in reference the output of another question or store/retrieve a question result value?
sorry if this is a newb q.
@yangabanga Depending on the database you’re querying, then yes. Either via joins in the Notebook editor and Custom Columns:
https://www.metabase.com/blog/joining-tables/index.html
https://www.metabase.com/blog/custom-expressions/index.html
or in SQL with Sub-Query variable:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#using-an-existing-question-as-a-sub-query