I’m trying to combine two questions and calculate them. I want to show calculation result in Dashboard.
I have two Questions.
Question A : total count of user records, refer from User table.
Question B : total count of order records, refer from Order table.
I want to show order counts per user.
Can I calculate two questions, like “Question B / Question A”?
Are the questions from two different databases? Or are the tables within the same database?
tables within the same database.
Up! I am also interested in this
is this somehow possible within the dashboard or within another question?
Would be great to get help on that
@alexhammerschmied You can use combine request from other questions in SQL. Have a look here: Divide two sql queries results
thank you very much. That made it a lot quicker to find
Hi @flamber, i have a question about this.
Right now i did this but when i filter the data of question 3 and question 33, this won't affect the result. I think this is because he only check the questions.
How is it possible to apply a field filter also on this result?
For example, i have a question for orders with the status paid, and for photoshoots with the status other then draft or in_review. I want to calculate the conversion% based on the two questions and when i use the filters i want also that my conversion% will be based on the two questions with the filter option.