Hi,

I want to analyze how many songs have been played by (e.g.) length, but count each song only once.

So imagine 10 times a song has been played, I want to know that 3 of them were 5mins long, and 2 of them 6 min, but not count every unique song only once. (so 5 songs were counted already)

So far I can only count unique users or total events, both do not do the trick.

The song played event has a songID property.

Any help is appreciated.