1

00:00:01,520 --> 00:00:03,100

Hello and welcome back.



2

00:00:03,320 --> 00:00:09,200

Last session we saw how do group members into different clusters and that we took example of in terms



3

00:00:09,200 --> 00:00:10,540

of age and salary.



4

00:00:10,550 --> 00:00:16,340

This time I'm going to show you how to group and clustered beats and this a very fascinating feature



5

00:00:16,640 --> 00:00:18,960

which I see people not using.



6

00:00:19,040 --> 00:00:24,560

And once you watch the video yourself and appreciate the how wonderful this exercise could be.



7

00:00:24,560 --> 00:00:30,890

So what I am will do is I'm for taking away all the fees from the area or off the table and I start



8

00:00:30,920 --> 00:00:31,870

from scratch.



9

00:00:32,210 --> 00:00:34,860

So if you have a couple of feet that includes the of joining.



10

00:00:35,160 --> 00:00:37,930

And I'll try to find four other fields which are.



11

00:00:37,970 --> 00:00:39,000

I don't find any.



12

00:00:39,110 --> 00:00:42,890

So let me start with a bit of joining I did of joining.



13

00:00:42,890 --> 00:00:50,120

I put that in trophies and what I get is if these are great these dates which are in the correct format



14

00:00:50,180 --> 00:00:54,950

as Excel can understand it they are sequentially placed in an ascending order.



15

00:00:54,950 --> 00:00:58,470

Now I'm with a right click on any one beat.



16

00:00:58,580 --> 00:01:06,260

Once they do that I we go back to the option which says group I click on group and I get a box which



17

00:01:06,260 --> 00:01:09,660

shows me one of the starting and ending in my beat up.



18

00:01:09,720 --> 00:01:12,950

And how would I want to group or cluster at this moment.



19

00:01:13,100 --> 00:01:15,320

I would have bought months and years.



20

00:01:15,380 --> 00:01:17,600

I don't need to breath control and then do this.



21

00:01:17,750 --> 00:01:20,930

If you simply click any one options it gets to them.



22

00:01:21,290 --> 00:01:26,140

So no this other double clicked it quickly give me your and month based classification.



23

00:01:26,180 --> 00:01:28,440

And that too in a sequence.



24

00:01:29,000 --> 00:01:33,110

So if you had a day Dow which spanned the world multiple years you'd be able to find that plane a very



25

00:01:33,110 --> 00:01:34,070

very nice screen.



26

00:01:34,220 --> 00:01:39,760

So let me find out how many people join in with your average month and for that to happen.



27

00:01:39,800 --> 00:01:45,280

Let me bring them in the main action area and then let me leave it.



28

00:01:45,680 --> 00:01:51,470

So I've been told that there was one gentleman or a person who joined in the month of February in the



29

00:01:51,470 --> 00:01:53,230

year of 1995.



30

00:01:53,420 --> 00:02:00,380

And a similar kind of trend I'm seeing as Diane Lane moves on you might tell me that this is a report



31

00:02:00,410 --> 00:02:06,610

which is very lonely and cannot be printed in a single ifour size paper.



32

00:02:06,920 --> 00:02:12,210

So now let me show you another trick you noticed as you broke the date into two components.



33

00:02:12,260 --> 00:02:12,960

It says yours.



34

00:02:12,980 --> 00:02:13,910

And the other.



35

00:02:14,270 --> 00:02:19,510

And similar thing I find in the rule section of this fuse box.



36

00:02:19,520 --> 00:02:29,590

Now what happens if I get the beauty of the month one and put it inside column what I get displayed



37

00:02:29,680 --> 00:02:35,030

I get month displayed on the column fuse that is horizontally and to what degree.



38

00:02:35,050 --> 00:02:40,780

Now it's a perfect compact report which can be printed on in a single ifour sized piece.



39

00:02:40,900 --> 00:02:44,720

And which exactly does the industry doctrine your wise and money wise.



40

00:02:44,770 --> 00:02:50,140

So if I try to find a train that which month has been the busiest in dozens of recruitment and I compare



41

00:02:50,140 --> 00:02:51,300

the numbers.



42

00:02:51,310 --> 00:02:55,950

I look at the month which is October instead of October November.



43

00:02:56,050 --> 00:03:01,390

These two months have been the busiest in terms of recruitment and which year I've picked up maximum



44

00:03:01,450 --> 00:03:02,980

amount of people in my team.



45

00:03:03,130 --> 00:03:08,620

If I compare the different numbers I've seen multiple instances of twenty five and one instance that



46

00:03:08,620 --> 00:03:14,600

was used to telling people where 26 people were recruited in the scene you're not sort of an idiot.



47

00:03:14,930 --> 00:03:16,160

You also want to find a trend.



48

00:03:16,170 --> 00:03:19,690

How has generally been dozens of recruitment work legally.



49

00:03:19,930 --> 00:03:26,800

So what I do is I even put DOJ below yours but then you would say that this is the same report we started



50

00:03:26,800 --> 00:03:30,330

from then I will support that yours.



51

00:03:30,340 --> 00:03:38,290

Let me touching and put it below puji as you could see from the cursor sign what I get month month of



52

00:03:38,290 --> 00:03:39,400

different heures.



53

00:03:39,410 --> 00:03:44,230

So generally how has it been all the different heures then data group offline.



54

00:03:44,230 --> 00:03:49,450

So again there are so many combinations that you can apply once you have broken down a date in two years



55

00:03:49,510 --> 00:03:53,030

and months and not only this if you want further trends.



56

00:03:53,110 --> 00:03:57,940

You can also apply percentage of row and column as we had discussed in the previous videos and you'll



57

00:03:57,940 --> 00:04:03,450

find a very very nice trend coming up and that you can exhibit in terms of jobs.



58

00:04:03,540 --> 00:04:07,430

So that was the biggest Automattic grouping.