Adding Secondary Categories To Your Visualizations

Quick reference

• 00:04 Okay, in this video,
• 00:05 I want to talk about adding secondary categories to our visualizations.
• 00:08 Now, up until now, we've just been using basically one dimension, right?
• 00:12 So we've been grabbing our breed, one dimension, one thing, and
• 00:16 then the count, right?
• 00:17 So okay, that's great while we're just learning, but
• 00:20 chances are you're going to want to do more than one thing at once.
• 00:24 How do we do that?
• 00:25 Well, we've kind of looked at this briefly in other videos,
• 00:28 all we need to do is drag a second dimension into our column.
• 00:30 So for instance, if we want the license type, we can do this.
• 00:34 And now this gets a lot more complicated.
• 00:37 So you're likely going to want to drill down into very specific things
• 00:41 using filters.
• 00:43 So we should set up a filter.
• 00:44 So let's grab license type and I'm going to control drag over to filters.
• 00:47 And you can see these are the different license types that we have, dog individual
• 00:52 female, dog individual license free, license duplicate, individual male,
• 00:56 neutered, spayed, neutered male, spayed female, and on and on.
• 00:59 Let's just say we want to determine how many are neutered males and
• 01:05 neutered females.
• 01:07 So we can apply that and makes it a little bit easier to read.
• 01:09 In fact, let me change this to a text table here.
• 01:13 And let's also drag in a filter of our count.
• 01:17 And let's just say from 500 to whatever.
• 01:21 And so now that brings it down.
• 01:23 And now these are on different lines, let's put them together.
• 01:27 There we go, down like this.
• 01:32 And so you can play around with these.
• 01:33 So here we have the breed on the row, and the column is the license type.
• 01:38 And this sort of makes sense because we have two license types.
• 01:40 So there's two columns.
• 01:41 This is neutered males.
• 01:43 This is neutered females.
• 01:45 Now we can see by breed, how many of them are neutered males and
• 01:48 how many are neutered females.
• 01:50 So very interesting and very easy to do just by adding other dimensions.
• 01:55 Now, you can do more than two.
• 01:56 You can do more than three.
• 01:57 You can do as many as you want.
• 01:58 We just again, just start dragging things over and then tweaking them and
• 02:03 filtering them to show whatever you want to show using that data.
• 02:07 So we've got here a basic text table.
• 02:11 We can play around with this with maybe a bar chart.
• 02:14 Here we have neutered males, neutered females, interesting.
• 02:20 We could instead of having the license type right here,
• 02:24 we could drag this thing into maybe colors.
• 02:27 And now it changes back into one chart, right?
• 02:30 But it's now broken apart by colors.
• 02:33 And maybe that's more interesting for your visualization, right?
• 02:36 So if we hover over here, we can see given anything, say golden retrievers.
• 02:40 We can see that 872 of them are spayed female and 799 are spayed male.
• 02:47 And we add this visualization.
• 02:48 It's kind of more interesting.
• 02:50 We could, if we look at pie chart, not so much, and pull over this license site.
• 02:55 So those are a couple of ways to add more than one dimension to your visualization
• 03:00 with the one category etc and very cool.
• 03:02 So that's all for this video.
• 03:03 In the next video, we'll look at creating custom measures.

Lesson notes are only available for subscribers.