Hi Team, I am facing difficult in creating visuali...
# gooddata-cloud
a
Hi Team, I am facing difficult in creating visualization between Program Name, Applicant Id & Review Round Id. Can you please help. I am able to create similar view between Program Name , Applicant Id & Intake Round Id.
y
Hi Anjali, Thanks for sending this in, happy to help. We are checking this internally, feedback will be shared soon.
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,