Hello, I am trying to join several views in the same explore. These views all have the same dimensions (date, id, language, country, type) and each of them has a different metric.
I need the union to be through a full join so I am choosing the full_outer option, but there are cases that are not on the left side but are on the right and they do not appear, why could that be? Being a full outer, shouldn't it bring all the cases on the left and all the cases on the right in addition to the matching ones?
I have tried all the relationship combinations but I can't get those cases to appear.
Any help?
Thank you!!