topic Re: Amanda's Netflix Data in Data Stories Gallery

Amanda's Netflix Data

Amanda — Thu, 06 Dec 2018 02:31:21 GMT

This report shows my watch data on Netflix from when I joined through November 5th.

eyJrIjoiNDY4ZWQ5ODUtNjEwNi00OWMxLWE1ZDEtOWQwZDc4MzdlNDkzIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9

Re: Amanda's Netflix Data

Anonymous — Mon, 10 Dec 2018 07:48:56 GMT

Pokemon :)

Re: Amanda's Netflix Data

Anonymous — Mon, 10 Dec 2018 07:54:21 GMT

Nice report!

But you see now why the relative date slicer is INSUFFICIENT!

If I want to select a SPECIFIC date or date range - I cannot do it...

This is so common scenario with my users.

We should be able BOTH -

1. To specify a default member in a slicer (and not only relative, but any defalt member using DAX)

2. Allow the users with simple click to choose any selection they like from the same slicer

Please make it happen!

Here is the IDEA to voteon:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19055692-slicer-default-selected-values

Thanks!!!

Re: Amanda's Netflix Data

Anonymous — Thu, 25 Jul 2019 08:21:54 GMT

Hey Amanda! Great report!

I would love to try something like this. How did you get all the Netflix view activity data?

Re: Amanda's Netflix Data

Amanda — Tue, 30 Jul 2019 01:36:55 GMT

In their account settings, they have a "Viewing Activity" button, which is what I used. It takes you to a page where you can download your entire viewing history as a csv. It's actually a lot easier than it used to be. I used to have to keep clicking "show more" until it all loaded and copy/paste the results out :)

Re: Amanda's Netflix Data

Anonymous — Tue, 30 Jul 2019 02:43:02 GMT

Thanks Amanda!

Yes I downloaded my Viewing Data from Netflix. But that .csv file just had two columns: 'Title' and 'Date'.

As I had few records, I manually entered the Genre and Duration fields. (But that's not the most optimal solution to do it right?)

I was wondering how you got the '#of Times Watched","Genre" and "Time Watched(min) data for your report.

Below is the snippet of the report that I prepared.

Re: Amanda's Netflix Data

Amanda — Wed, 07 Aug 2019 00:54:16 GMT

For that I used this API since Netflix won't give you that information: https://www.omdbapi.com/

IMDB and Netflix don't always use the same name for shows and movies so I did need to do some data cleansing to get everything to align perfectly.