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.
BG
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
