Unable to join two datasets

[gian]

Hello,

I am running into an error when I modify my already-existing join configuration between two datasets.

• Everything works fine if I keep my currently selected columns from each dataset.
  

  
  
  The left table column (date-utm_id) used in the already-working join configuration is a calculated field and no problem with it.
  
  

• Once I select the new column (init_or_sub-utm_id) I get a generic error with not details/explanation.
  

  
  
  
  

Note: init_or_sub-utm_id column uses a parameter in its calculation and it is the only difference I could thing of.

More context: the reason I am using a parameter is to the able to switch between two views later on, once I publish the dashboard. One view based on initial visit date and one based on subscription date.

Is there anything I am missing?

Thanks.
Gian Marco

[Brett]

Hi @gian,
To my understanding when dealing with table joins in QuickSight, you are unable to join based on a calculated field utilizing a parameter as it joins prior to the data being aggregated. I would suggest trying to handle the join based on other fields if possible.

[gian]

@Brett thanks. Is there some documentation that goes more into details about that topic?

Gian Marco

[Brett]

Hi @gian,
QuickSight documentation is a bit light on the limitations regarding field usage in dataset joins. The only documentation they have listed out can be found at the below article:

Joining data - Amazon QuickSight

This determination was found more through trial and error.

[gian]

@Brett it makes sense, thank you for your answers.