I have a dataset and want go group same ID's and count the frequency. The aggregation operator offers quite a lot of options, but not this one. Which operator can you suggest?
The event_table lists user_id's, creationdates. Now I want to count home many of the same user_id's are in the list, so to say building groups, counting the frequency - let's say userid 223 -> 21
I got it by using the Aggregate operator with the group_by attributes and the count aggregation attributes –
best
M