Visualisation of Dataset in Quicksight shows different values depending on showing the indiviual or joined dataset during a specific time frame (time change)
Hi @melina.seemueller ,
Can you provide further elaboration on the joins that you used to connect your datasets? My initial guess is that something is happening where duplication of rows is occurring and that is why you are seeing differences in some of the values. But, further details regarding your situation would be helpful.
Hello @JacobR, I used a full join and used the date as join key. I joined every additional dataset with the first one. I changed that into a left join which didn’t make any difference.
Hi @melina.seemueller ,
I think I see the problem here. It will not make a different between what type of join you use because of the field that you are using as your join key. Using a date field is often not recommended to be used as a join key from lack of uniqueness as a main reason for most of the time. Is there another field that you can use as the join key? Often fields that are unique identifiers (order id, transaction id, etc.) are often the best to use when joining datasets.