Join Two Tables

[SoudarapuN]

Hi team,

I have a requirement where I need to display the number of records in one table that are associated with each record in a referenced table.

For example, Table A is a reference field in Table B. I want to show, for each record in Table A, how many related records exist in Table B.

Specifically, if Table A is the User table and Table B is the Incident table, I need to display how many incidents have been created by each user. The output should be in a list format showing each user along with the count of incidents associated with them.
it is not possible using reports aggregation.it is an urgent requirement.Please help if anyone knows
Thank you

[SoudarapuN]

but how to show same type of fields to. When i try group By remaining columns were not shown right?

[Robert H]

Hello @SoudarapuN ,

Up to now you never mentioned anything about showing additional fields.

Use the script I provided as a starting point and modify it as per your true requirement.

There is no way to achieve this in a report / visualization.

Regards,

Robert

[SoudarapuN]

if not report how can i do that. Requirement is to show exact the picture in dashboard .Can i do that by list type .

[Robert H]

Hello @SoudarapuN ,

As mentioned before, you need to use a script.

Regards,

Robert

[SoudarapuN]

which script Business Rules?