Use parameters across different ids in 2 tables

[apjvinod]

Hi @Prajakta

Are you getting server timeout issue , when running Quick Sight 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 Quick Sight 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 Quick Sight.

Quicksight - Dynamic function lookup id

Posting customer question (submitted by awn1995 via stack overflow) and couple of options to accomplish similar outcome. Is it possible to use another function or a parameter in place of the absolute value in a lookup ID? I have a table of data that looks like this: Date Value 2022-01-01 1,264 2021-12-31 1,232 2021-12-30 1,221 2021-12-29 1,121 I’ve created two parameters to store date values, one called “latestdate” which just carries the latest date value (top of Date column…