Avoid email duplicate by Using 'GROUP BY' in Console Analytics
I have one requirement to group by the records by email.I have tried the "Group Result" functionality. If I gave only email column its working fine.Once I added the Name & ID, it will again show the duplicate values. Because ID have unique value.
How to avoid the duplicate report
Ex: I have below 3 columns
3.Contractor Email ID
Based on columns, I need to groupby the email ID alone.