Hi, I have dashboard with 2 questions (edit: to be clear, they are interrogating two different databases).
Question1 returns 5 and question2 returns 4.
Is there a way to visualize in the dashboard the sum of what the two question return (in this case 9)?
Thanks,
Carlo
If all the underlying tables are in the same database, you can use a “native query” to achieve what you are after.
Yes, I’m aware you can do a + b in a SQL query.
But since Metabase allows for different connections, thus making you able to have, in the same dashboard, questions interrogating different databases, I’m interested in a more general solution.
Have you resolve that problem for a more general solution? Can you help me?
@mrizzotto It is not possible to do queries across databases. You would need to put all your databases in a warehouse. And then you can use Custom Expressions: https://www.metabase.com/blog/custom-expressions/index.html