How to remove duplicate records from reports

[poornima batchu]

Hello Experts, 

I'm trying to create a bar graph report on Task_sla table for incidents and Requested Item. But there are few cases where two SLA's are running for single case. In the report it is showing two records with same case number how can I filter out the duplicate records and show exact count

[AndersBGS]

Hi @poornima batchu ,

You need to understand why there is a duplicate entry and then adjust your filter to see exactly the specified requested output. For me it sounds like your filter isn't narrow enough.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Jamie2308]

Hey @poornima batchu, did you find a way to resolve this? I'm dealing with a similar issue on the Task SLA table, but instead I've got multiple SLA tasks running from Problem records that I need to filter out. Thanks, Jamie

[Jackie Mondora]

Can you show how you'd handle it if you needed more than 1 column in the evaluation. Like here you have 'name' only. What if it were 'name' and some other field?

[Slava Savitsky]

I am afraid the way you formulate the problem is incorrect. These records are not duplicates. Tasks can have multiple SLAs associated with them, so if you run a report against [task_sla] table, it is to be expected that some of the tasks will be listed multiple times because the entries you get back are SLA instances and not the task as such. If you want your report to display each task only once, you should select a different table, such as [incident], [sc_req_item] or [task].

[PJ363182]

Have you ever got it sorted?