How to find the time that people watch stream the most

Hi, I’d like to know the point of time (hour) that my users watch stream the most but i don’t know how to do it. I tried to divide into many durations but ofc it was incorrect, for example: someone could join at 2 am and leave at 4 am.
Thanks for supporting me !

Hi @thecuon119
can you try to create a join_HH extract('HH',{join_stream_time} and leave_HH extract('HH',{leave_stream_time} field and the the results within a table? you can check if the calculation is realy giving you the right/expected numbers.

1 Like

hi @thecuon119 - Can you check the data preparation stage whether the calculated field is populated properly or not?

Regards - Sanjeeb

Hi, @thecuon119. We hope @ErikG;'s or @Sanjeeb2022’s solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution" (check box under the reply).

Ah sorry for forgetting to reply. I used join stream time instead of concatenating them. It was still usable.

1 Like

Thanks for the update @thecuon119! :slight_smile:

1 Like