Hello and welcome back.
Last session we saw how do group members into different clusters and that we took example of in terms
of age and salary.
This time I'm going to show you how to group and clustered beats and this a very fascinating feature
which I see people not using.
And once you watch the video yourself and appreciate the how wonderful this exercise could be.
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
from scratch.
So if you have a couple of feet that includes the of joining.
And I'll try to find four other fields which are.
I don't find any.
So let me start with a bit of joining I did of joining.
I put that in trophies and what I get is if these are great these dates which are in the correct format
as Excel can understand it they are sequentially placed in an ascending order.
Now I'm with a right click on any one beat.
Once they do that I we go back to the option which says group I click on group and I get a box which
shows me one of the starting and ending in my beat up.
And how would I want to group or cluster at this moment.
I would have bought months and years.
I don't need to breath control and then do this.
If you simply click any one options it gets to them.
So no this other double clicked it quickly give me your and month based classification.
And that too in a sequence.
So if you had a day Dow which spanned the world multiple years you'd be able to find that plane a very
very nice screen.
So let me find out how many people join in with your average month and for that to happen.
Let me bring them in the main action area and then let me leave it.
So I've been told that there was one gentleman or a person who joined in the month of February in the
year of 1995.
And a similar kind of trend I'm seeing as Diane Lane moves on you might tell me that this is a report
which is very lonely and cannot be printed in a single ifour size paper.
So now let me show you another trick you noticed as you broke the date into two components.
It says yours.
And the other.
And similar thing I find in the rule section of this fuse box.
Now what happens if I get the beauty of the month one and put it inside column what I get displayed
I get month displayed on the column fuse that is horizontally and to what degree.
Now it's a perfect compact report which can be printed on in a single ifour sized piece.
And which exactly does the industry doctrine your wise and money wise.
So if I try to find a train that which month has been the busiest in dozens of recruitment and I compare
the numbers.
I look at the month which is October instead of October November.
These two months have been the busiest in terms of recruitment and which year I've picked up maximum
amount of people in my team.
If I compare the different numbers I've seen multiple instances of twenty five and one instance that
was used to telling people where 26 people were recruited in the scene you're not sort of an idiot.
You also want to find a trend.
How has generally been dozens of recruitment work legally.
So what I do is I even put DOJ below yours but then you would say that this is the same report we started
from then I will support that yours.
Let me touching and put it below puji as you could see from the cursor sign what I get month month of
different heures.
So generally how has it been all the different heures then data group offline.
So again there are so many combinations that you can apply once you have broken down a date in two years
and months and not only this if you want further trends.
You can also apply percentage of row and column as we had discussed in the previous videos and you'll
find a very very nice trend coming up and that you can exhibit in terms of jobs.
So that was the biggest Automattic grouping.