Forum Discussion
Calculate unique viewership duration
hi, I have that captures viership of media/video content like netflix shown in table below. Row 1 captures viewership of customer "123456" watching video "Short Movie 2" that is 240 secs in durat...
I thought about it some more and here is what I would do:
For each customer and video collect all the viewed seconds ( via GENERATESERIES ) into a table variable and then do a DISTINCTCOUNT on the second values. That has the same effect as EXCEPT but across all video fragments.
lbendlini am very keen to try your proposed solutions, however I am having trouble understanding how to execute it
Provide some more sample data.