cancel
Showing results for 
Search instead for 
Did you mean: 

Story report Duplicate records Issues

RakeshDumla1
Discoverer
0 Kudos
738

Hi Team,

Currently, I am experiencing huge duplicate records in the Story reports when creating it for performance form templates to Capture the Section Rating - Objective/Competency and Overall rating. 

Please help me how to fix this 

MissJP
Explorer
0 Kudos
Is the duplication due to 'Other Ratings' returning more than one User ID? If this is the case you could create a calculated column that checks this (IF formula) and add a query filter to exclude one of the IF statements.
View Entire Topic
gloriakurz
Explorer

Hi,

When the query starts with employee entry then multiple records appears. It will be necessary to start the query with the template table from performance. You will access the data for a particular template without multiple records for one employee. 

I hope that helps and feel free to contact me if you have further questions.

Best regards

Gloria

RakeshDumla1
Discoverer
0 Kudos
Hi Gloria, Thanks for the update.. I have tried with your answers, I am able to resolve 80% of the duplicate issues with the Aggregate and Cross tab options. Now I am having another issues that when I Employee records is showing better with removed duplicates, The issues is the count column still showing huge number like which is affecting the chart based analysis.
gloriakurz
Explorer
0 Kudos
Hi Rakesh, sorry for the late response. I was out of office.If you still facing the issue with the count column then please feel free to contact me and share the configuration via screenshots. My email: gloria.kurz@mhp.com
Cibin_Kurian
Discoverer

Hello Rakesh, Hello Gloria, Could you able to solve this issue? Rgds Cibin.

Mariola_I_821
Explorer
0 Kudos
Hello, could you send us the solution how to fix it? I have the same issue when I have created the report Story for LMS (I choose the two sources: Learning History and Assigned Items) and I have a duplicates also.