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 contr…

Hi @sbaskax To use a denominator for all rows you can look into PRE_FILTER / PRE_AGG calculations. Using level-aware calculations in Amazon QuickSight - Amazon QuickSight Use level-aware calculations in an Amazon QuickSight analysis to insert a window or aggregate function into the or…

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 wil…

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

Hi, Try to create new dataset and union two tables, but first you have to modify them Add to table A new column for example datasetname = TableA Modify table B and add empty columns Subject, Marks, Result after column Roll no. create new column datasetname = TableB

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

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

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

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]

How to use two dataset in single visualization

Q&A

sbaskax April 24, 2023, 10:44am 9

Hi @KarolinaSB , any luck on this thread

How to create a calculated field based on the metrics from 2 different dataset?

Topic		Replies	Views
How to create a calculated field based on the metrics from 2 different dataset? Q&A data-source , analysis , parameters , feature-request , quick-sight , dataset , calculations	3	985	July 21, 2023
Filter between two visuals from different datasets Q&A feature-request , quick-sight , Business-Intelligence-Engineer	3	78	June 16, 2025
Is it possible to use fields from two different datasets and put into one visual? Q&A database , quick-sight , dataset , data-connectors , Business-Intelligence-Engineer	6	3041	October 11, 2023
Two Dataset working together without doing any joins Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	572	February 21, 2024
Can you define a filter that can work across visuals that have 2 different datasets? Q&A quick-sight , dashboard , filters-controls-and-parameters , Business-Intelligence-Engineer	3	306	October 11, 2023

How to use two dataset in single visualization

Related topics