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

Q&A
, , , , , ,
1

Hi Team,

I have 2 different datasets.
1)rl_transformation
2)test visualization.

I have one metrics calculated_weight in rl_transformation dataset & in test visualization dataset i have target metric.
now i want to divide calculated_weight by target .

The formula is
rating= calculated_weight / target.
=24,076.46/32,593,743
=0.07387(expected answer)

I have some common filters(parameter) on both dataset.
age,gender ,region and date.

and few diffrent filters on rl_transaformation dataset.

after applying above filters whatever the data is filtered out on both dataset data will be taken into consideration.

image
image1040×171 8.52 KB

image
image1366×679 60.7 KB

I have tried this using creating parameter (calculated field) but result is not correct.

2

Hello @suraj.nimse !

Looks like someone ran into a similar issue in this post thread if you want to check it out. Have you tried this yet? > Using level-aware calculations in Amazon QuickSight - Amazon QuickSight

3

I’ll try Using level-aware calculations in Amazon Quick Sight.
Rest all solutions tried mentioned in the following similar issues.

It will be great if any other solution is there.

4

There’s no ability to create a calculated field based on metrics from 2 different datasets.

I can mark it as a feature request.