Tagging data columns from multiple data sets in AWS Quicksight Q

I am using AWS Quicksight Q for performing a task on 2 datasets. I added both the datasets
1.) Number of Users (this gives me the number of users )
2.) Number of Jobs Posted (this gives me the number of jobs posted by every user of the system)

On Quicksight Q, I want to get " Top 5 Accounts by Number of Users and Number of Jobs Posted"
Logically Number of Users must be tagged from Dataset 1 and Number of Jobs Posted must be tagged from Dataset 2.

But it gets data from just 1 dataset as seen in the screenshot. At a time it can only refer to one dataset.

Hi @Shambhavi,

Q can’t use 2 datasets at the same time when answering questions. You’ll have to join your 2 datasets and use the combined dataset in your topic.

2 Likes