Report - show duplicates

[cgedney]

I have built a table and I have two columns (Application (Reference to application table) and (User Access (Reference to a user table)). I have a couple other columns in this table, but I am only worried about these two. What I need to be able to do is build a report that shows only the duplicate records where these two columns are the same. 

Example:

MyTable consists of columns app, useraccess, pizza and pie.

MyTable

row    app             useraccess        pizza         pie

------- ------------ ------------------ ------------ -------

1         app1           useracc1           pizza1       pie1

2         app2           useracc1           pizza3       pie2

3         app1           useracc1           pizza4       pie3

4         app3           useracc2           pizza 1      pie2 

I want to build a report in which rows 1 and 3 are displayed. I cannot figure out how to get the report to do this.

Thank you, Charles

[mattystern · Accepted solution]

Hi cgedney,

Not really sure how to do this in a listed view, but if you put this into a chart, you could use "Additional Group by" to achieve something like this:

Click "Additional group by" on your table"

Set to interested fields

Group by one and stack by the other

Result:

You can then click the bar to get the list view of this once the report is saved.

Let me know if this helps!

-Matt

[cgedney]

Thank you Matt! Not exactly what I was hoping for, but it did the trick.

[jjimenef]

Hello,

Has anyone found any criteria to show duplicate entries in reports? For example assets with the same serial number.

[mattystern]

Hi @jjimenef 

You can follow this post. From alm_hardware, the javascript call is: 
Serial Number IS ONE OF 

javascript:new myFilterUtils().filterByCount('alm_hardware'
 'serial_number'
 '>'
 '1');

 
If you don't want to create a script include or are unable to, you could follow one of my favorite posts on sorting grouped by lists. This won't filter out records where there is one serial number, but it'll show duplicates with the COUNTDESC option.

Hope this helps!

-Matt