One of the results of an sql query is 965 as you can see and the other one is 653 . i want a query where i can just directly use these results to divide 965/653 and not copy past the whole query
@louisc Instead of creating multiple topics without example queries of what you are trying and at a minimum including which database type you're using, but preferably "Diagnostic Info" from Admin > Troubleshooting, then it's really difficult to help you. And if you never read the documentation pages, then you are basically just looking for someone else to do your work.
But this should work select {{#123}}/{{#321}}
For reference: https://www.metabase.com/docs/latest/users-guide/referencing-saved-questions-in-queries.html
1 Like
@flamber yes sorry in postgresql . I read the documentation but it is sometimes too specific. But thannk you for your help.
select {{#123}}/{{#321}} I did this but the result thats comes out is 0. when i add them up it works fine but not for the division.
thanks again
@louisc Try select {{#123}}::float / {{#321}}::float
Otherwise post the query of your two questions.
work fine thank you!
This solution does not work with dashboard filters. Any way of doing that?