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…

How to use two dataset in single visualization

Question & Answer

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?