How to use two dataset in single visualization

Question & Answer
,
1

Is this possible to use two dataset in single visual ? based on multiple filter my numerator(based on dataset A) and denominator (based on dataset B ) needs to populated. i tried arrive this by joining these two dataset but it is giving me wrong output.

Example:
School , city & state are in control tab, based on that i want to arrive subject wise %P & %F

Sample data:

image
image1153×1451 54.8 KB

2

Hi @sbaskax - You can create a custom data set by taking both data sets and do a left join A and B on Roll No. This custom data sets can be used in your analysis.

see the details in the below link - Creating a dataset using an existing dataset in Amazon QuickSight - Amazon QuickSight

Hope this will help you.

Regards - San

1 Like
3

Hi @Sanjeeb2022 , I already tried this but i am not getting required output.

4

Hi, Try to create new dataset and union two tables, but first you have to modify them

  1. Add to table A new column for example datasetname = TableA
  2. Modify table B and add empty columns Subject, Marks, Result after column Roll no. create new column datasetname = TableB
1 Like
5

Hi @KarolinaSB , In this case then how can i differentiate numerator & denominator . I mean what function do i have to use.

6

For exmaple you can create calculated field and use ifelse function to differenciate numerator & denominator based on new column datasetname

1 Like
7

Sorry, I couldn’t able to understand. can you pls share a sample formula or any reference link related to this

8

Hi @KarolinaSB ,

As you suggested , i have append two datasets and tried visualizing , denominator value is reflecting in single row. whereas i want to use i want to use it as denominator for all the rows to arrive %

image
image1121×687 48.6 KB

9

Hi @KarolinaSB , any luck on this thread

10

Hi @sbaskax

To use a denominator for all rows you can look into PRE_FILTER / PRE_AGG calculations.