Question

Total events but with unique event property value

  • 21 September 2023
  • 2 replies
  • 92 views

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.


2 replies

Badge +1

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 fluxus executor apk or total events, both do not do the trick.

The song played event has a songID property.

Any help is appreciated.

 

Thanks @Amelia, I think somehow your answer got lost.

Reply