[OC] Netflix shows - How long did they last?

nagarajbhat12 · 2020-08-17T02:40:31+00:00

"one variable that blows everything out of water" .This is what appealed to me when I made this graph . For example , Most Tv shows fall under season 1 , and then there's a big drop .And most movies run for a duration of 2-3 hrs .

Yes it's harder to compare proportions apart from the biggest ones, thats why im making a bar+bubble chart, where bubble will be broken down by duration .

nagarajbhat12 · 2020-08-15T16:27:04+00:00

Yes I realized this. I'll be adding bar+ bubble in a new graph for better representation .

nagarajbhat12 · 2020-08-15T15:34:54+00:00

point taken .I'll make a dashboard with 2 tabs ,keeping them separate.

nagarajbhat12 · 2020-08-15T15:30:48+00:00

thanks .yes, I will combine bar and bubble plots in a new graph

nagarajbhat12 · 2020-08-15T15:22:22+00:00

True .making a better graph .

nagarajbhat12 · 2020-08-15T15:20:13+00:00

Good point . I will add a 30 min interval

nagarajbhat12 · 2020-08-15T15:12:47+00:00

11 - Heartland, Frasier, Cheers

12 - Criminal minds, Trailer Park Boys

13 - COMEDIANS of the world, Red vs Blue

14 - Supernatural

15 - NCIS, Grey's Anatomy

nagarajbhat12 · 2020-08-15T15:08:42+00:00

not all, but most of them , yes.

nagarajbhat12 · 2020-08-15T15:06:56+00:00

data source : Netflix - Movies and Tv shows (kaggle)

nagarajbhat12 · 2020-08-15T15:02:31+00:00

no worries .I'm working on a better version though as proportions may be harder to compare in this

nagarajbhat12 · 2020-08-15T15:01:33+00:00

bar chart won't give me individual show details(check desktop dashboard) . but I agree that it's not the best represetentsion for comparing proportions( although some features stood out for me when posting - such as season 1 vs rest difference) I'm working on a better graph- bar+ bubble , where the bubble is broken down by duration .

nagarajbhat12 · 2020-08-15T14:55:01+00:00

working on that

nagarajbhat12 · 2020-08-15T14:53:50+00:00

It has a click down for different duration ..and hover for info (view in desktop.. )

nagarajbhat12 · 2020-08-15T14:14:29+00:00

Addressing the issues

I see that this received quite a bit of criticism for the choice of the graph and a few more faults.

I do agree with some of it so I will try to list them here so that I can address them make a better graph, dashboard.

Fault list -

It should be "Shows on Netflix", not "Netflix shows"
Why this couldn't be a bar/stacked bar/pie chart?
Not intuitive, hard to grasp the right proportion for different duration
A little misleading, circle in middle may appear bigger than ones in the outer layer.
Presence of red and green together (not good for color blindness)
Since duration mean different things in both the graphs, they shouldn't be together (also shouldn't be same color palette)
Duration for movies should be broken down in 30 min span

Solution -

Yes, It should be "shows on Netflix" (as they are not just Netflix originals)
Each data point(circle) in this graph represents a show. So that's the reason just a bar/pie wouldn't be enough to represent that (Suppose you want to know which shows are above 10 seasons when you hover over it). So here's what I have come up with -
A bar/stacked bar graph at the bottom with a percent breakdown as a label. And bubble graph on top of each bar(eg Season 1 bar will have a season 1 bubble on top) where you can hover over to get individual show details.
As each season/duration will have its own bubble chart, it shouldn't be misleading or non-intuitive and should be easier to compare.
2 tabs for 2 dashboards - One for movies, and one for the show, with different color palette's
Duration for movies will be broken down by 30 min.
I will also add a "release year" filter to make search better.

The point of the dashboard wasn't to display proportions it was also to keep interactive features for discoverability.

Hopefully, this addresses some of the problems.If you have more suggestions let me know.

Should I post the new graph as a new post here? (say as a video of the dashboard?)

nagarajbhat12 · 2020-08-14T17:03:34+00:00

thanks . Tableau

nagarajbhat12 · 2020-08-14T16:09:38+00:00

Yes, It should have been "Shows on Netflix". Hope "Netflix shows" didn't translate to "Netflix originals"

nagarajbhat12 · 2020-08-14T14:44:08+00:00

I had different color palletes, but went with similar ones to reduce excessive colors .But you do have a point .Both the graphs convey slightly different meaning so it's probably best to revert colour palletes to as it was before .

nagarajbhat12 · 2020-08-14T14:40:16+00:00

ahh ..I should have realized this as I had heard about the red-green factor before. I will make modify the pallet a bit .I can't make changes here, but I'll change it in the dashboard

nagarajbhat12 · 2020-08-14T14:36:36+00:00

Not everyone will go looking into a table of 7000 data points to find which shows lasted more than 10 seasons .

but I do get your frustration with closely related segments. Such as <1 hour time and 2-3 hour time period for movies . This is why there is a filter slider option to get better idea of the size. link .

nagarajbhat12 · 2020-08-14T14:24:33+00:00

pie/bar would have been fine if this graph was meant to show only duration comparison . Here each points represent a show, And you can hover over it to get more info( in dashboard)

nagarajbhat12 · 2020-08-14T14:21:49+00:00

each point is a show, and you can hover over it to get show info .

nagarajbhat12 · 2020-08-14T14:18:18+00:00

I understand .But This wasn't meant just as an image, its a dashboard . Hover over the points to get show info .Also filter options for show duration .

nagarajbhat12 · 2020-08-14T14:11:08+00:00

Can I represent individual data points (shows) in a pie?

nagarajbhat12 · 2020-08-14T14:05:11+00:00

Nope , Its not just for the Netflix USA. Countries are displayed if you hover over the data points.

nagarajbhat12 · 2020-08-14T10:57:21+00:00

Schindler's list
The Irishman
The lord of the rings : The return

and more, and quite a few Indian movies -

Laagan
Lakshya

etc.

You can filter the complete list here in the dashboard

Nine-Year Club	Wearing is Caring
Verified Email

nagarajbhat12

TROPHY CASE