How to export the group by result records list from table?

[Indira Priya Da]

Hello Community,

I have applied the following filter on sysevent table and then group the results using the 'created by' field. 

>Name = login>Created on Yesterday.

List Count after applying the filter = 206363

list count after applying the group by = 9007

I would like to export 9007 records, when I try to export to excel its exporting all the records i.e. 206363 instead of 9007. Please guide me is there any way we can export only group by results.

Appreciate your quick assistance on this.

Thanks & Regards,

Indira Priya Darsini M.

[Anurag Tripathi · Accepted solution]

this is how it would export, there is no way to export the data grouped.

the 9007 count you see is the individual groups, total records is still 206363.

You can play in the Excel i guess to get the desired result.

-Anurag

[Indira Priya Da]

Thanks Anurag for the quick response. I exported the results in excel and then deleted the duplicates from created by field using the Delete duplicate button, but I found the difference between Group by results on the list and excel unique count. So, I wanted to export the actual group by results from the list and then do the comparison with excel results.  

Thanks & Regards,

Indira Priya Darsini M.

[Anurag Tripathi]

Im afraid that is not possible.