Hi Anjali,
Thanks for your patience while we investigated this.
After
impersonating and reviewing the issue, we identified the possible cause of the visualisation breaking when displaying
Review Round ID ,
Program Name and Application Id. It appears that the way the LDM is structured is leading to the generation of complex queries, which in turn is causing the error you’re experiencing. Based on our logs, we are seeing a data error. The error occurs when the system tries to generate a very complex query, which then times out.
A possible workaround is to try filtering the data by
Review Round ID and selecting fewer options (e.g., 5 or less at a time). Please note that the more IDs included in the filter, the longer it will take for the visualisation to load.
We also noticed that in the
Application dataset,
Applicant ID is defined as the primary key but contains duplicate values. Duplicate primary keys can impact both performance and the correctness of results in visualisations.
We recommend reviewing this and, if possible, ensuring uniqueness. It may also help to apply indexing on frequently joined columns to improve query performance.
I will also share link to the test report via dm for more context.
Please let me know if the above helps.
Best regards,