SELECT DISTINCT and SUM in a data list
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.....