SELECT DISTINCT and SUM in a data list

Bart shared this question 3 years ago

I am having a data master with many records holding an ip and a catagory. I use a SELECT DISTINCT to populate the list with only 'unique' ip's.

This populates a data list with:

ip : category : count

However, for each IP address I want to show the sum of total record in the database and a concat of the categories for that ip.

I managed to do the sum/count with onClick, setValue to Count:

DataCount [ Filter [ datamaster_connections, source_ip = value:currentRow;source_ip ] ] ]

This works, but I want it done OnLoad or at least all records at once onClick (now it is per row a click). As soon as I copy the event to onLoad, all record show the same count.....