Comments
-
Hi, Matt, This is what I wrote , but I did not get any output. Can you please help me -- What is missing here? Thank you very much. Olivia CASE WHEN (SUM(CASE WHEN `date`> (CURDATE()-7) and `Category`<>'Avg Watch Time (Sec)' and `Category`<>'Avg Watch Percentage (%)' THEN `Total` END)) = 0 THEN 0 ELSE(AVG(CASE WHEN `date`>…
-
Hello, Smurray, thank you for your help. I've looked at this report, but it only gives me the title for each individual videos, what I need is the playlist titles so that I can add a filter for the playlist. For example, our youtube channels has playlists eventA, eventB, eventC etc, under each playlist, there are several…
-
NO, I am still hoping someone can help me with it. Thanks.