SELECT DISTINCT and SUM in a data list

Bart shared this question 3 years ago
Answered

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.....