Use parameters across different ids in 2 tables

Hi @Prajakta

Are you getting server timeout issue , when running QuickSight SPICE refresh when joining messages & leads table and whats the underlying datasource ?

one alternative approach is to create multiple datasets and then do the join in QuickSight SPICE

  1. create one dataset for (leads, customers, accounts) tables joined and enable SPICE refresh
  2. create second dataset with message table and add the first created dataset and establish the join .

In addition please look into the below post for sample approach to implement the dynamic lookup in QuickSight.

1 Like