Calculate two questions

Get Help
1

Hi

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”?

2

Are the questions from two different databases? Or are the tables within the same database?

3

tables within the same database.

4

Up! I am also interested in this

5

Hi people,
is this somehow possible within the dashboard or within another question?

Would be great to get help on that :slight_smile:

6

@alexhammerschmied You can use combine request from other questions in SQL. Have a look here: Divide two sql queries results

1 Like
7

thank you very much. That made it a lot quicker to find :slight_smile:

8

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.