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

[Saurav11]

Hello,

What you can do is use group by field with the number field so it will give you the count of only unique records.

Please mark my answer as correct based on Impact.

[Amit Gujarathi]

HI @poornima batchu ,
I trust you are doing great.
Please refer below video for reference for solution for your use case

[Sebastien C]

Hi,

Not possible to put javascript in the filter - With the "is" operator, system wants to retrieve one value from the list.

Kr,

[vishnumaaya]

if you can please tell us the exact filter? I am not sure how to write that javascript filter.