- [Instructor] All right, what we're going to be doing today
is comparing, looking at this table of data in Google Sheets
with looking at the same table of data
in a program called Notion.
And we're going to act like
we're looking for the same,
and in simple answers from each
and talk about how we get them
and if we can get them.
So the first thing that we had to do
is add a column with a unique identifier.
Let's call it title column in Notion
and it's just made everyone different
but I kept them in number.
So you'll see that as we go through it.
And then another thing to keep in mind
is that each of these properties in this table
is predefined as a specific type.
So if I were to come into the table over in Google Sheets
and change this date to something that's not a date
and hit enter, it would be fine.
It would leave it.
It will cause a problem later when I want to analyze it.
But in Notion you have to define these.
So ship date, the property type is date already.
So this is going to be more strict
when you're entering data in Notion.
But it's also going to make it less prone to errors
when you try to analyze these things
because you already know
that these property types are right.
And we'll look at a few other types of data in Notion.
The ship mode,
if I right click on it and go to property type again,
is a select,
meaning that it can be one value
but selected from a limited field of values.
Category is the same way.
And then quantity in each are both defined as numbers.
And the total field is also a number
just because I copy and pasted this from Google Sheets
but it's a multiplication of quantity in each.
So if you were just doing this table in Notion,
you would have to go to property type
and make it a formula.
And that formula would be,
what we want to do is quantity times each.
So let's left click on quantity,
then put multiply operator
add an each and click done.
All right, so that's the property type of formula.
And we're ready to go to the next step.
Let's say that we're trying to look at our sales
and see the total amount of sales by category.
So this would be simple in Google Sheets.
What we would do,
well, there's lots of different ways to do it
but I think the easiest way is,
to go to data and do a pivot table.
We'll tell it where the source of the data is,
and click okay.
And we will put it on the existing sheet right here.
Click on, okay.
And create the pivot table.
Okay, so we said we wanted to look at the category
we'll add the category in
and then the values, we'll do totals.
Now I'd spend more time on how to create that pivot table.
But the point of this video is to compare the two.
If you want more information
on how to create pivot tables in Google Sheets,
I've linked to a full tutorial
in the upper right hand corner of the screen.
You can check that out if you want.
But here we have this simple breakdown of sales by category.
And you could do this different ways.
So that's a sum.
You could do a count, the sales.
And we have one to 13 different options here.
Let's change it back to sum
and come over and do the same thing in Notion.
All right, so the concept of the pivot table
does not exist in Notion,
but what you could do,
is just look at this table in a different view.
So, we'll drop down this box where it says show all
and we'll change it right now to a board view.
And you can control this board view
by left clicking on group by,
and you can choose one of the two select properties
that we had talked about.
So these are properties
that can only be a limited set of values
and do it by ship mode or category.
So we'll choose category and let's look at these totals.
So furniture is 23,000, furniture is 23,000.
So you can get to the same answer in Notion.
It's going to look a little bit differently.
It's not going to hide the detail.
It's going to show to it you,
but you can just look at the top right.
So, so far we're able to do the same thing
in Sheets and in Notion
as quickly get to these sums by different categories.
Now we'll touch on one major difference here
in Notion and in Sheets,
is that you could just click and drag these records.
So let's say this sale of furniture
really was office supplies.
You could just pull it over and you could move it that way.
And that updates the record.
So if you were to go back to the show all
and look at 2545,
that's updated the office supplies.
Let's change it back to furniture right now.
And we'll go back to that other view.
Now, if you remember in Sheets
you could do these different functions in Notion
you can select from a lot more.
And all of these operations
can work on different fields if they make sense.
So the count values you can do that for all seven fields.
Marks only makes sense for three
because you can't do the marks of the text field.
Say you wanted to filter this data
to not show technology for some reason,
in Sheets, you could easily just add a filter
on the category and uncheck technology.
Now we come over in Notion.
We want to do similar things.
So we will just use a filter.
This is going to work the same.
Going to filter on category,
anyway we'll say where category is not technology.
All right, so that hides the data here,
and gives you a sum of zero.
We'll go back to the main table view in Notion,
and then we'll do something
where I think Notion kind of falls apart.
But it's something I think
you would do relatively often in Sheets.
So if you wanted to do this,
let's take the filter off first.
We'll take the filter off of the pivot table,
but in Notion, filters are specific to the view.
So that filters not on this table.
We'll go back to the board view
and we'll go to filters and we'll remove that row.
So if you wanted to analyze the sales by furniture,
and then you wanted to do it by ship mode,
so we'll add another row, we'll say ship mode.
So this is a furniture.
And then you could look at it
by the amount that you shipped
via second-class and standard class.
If you try to do something like that in Notion
there's not an easy way to do it.
Now, you could make different views
and one of the views would be furniture.
And then you could store it within that
by second class and standard class,
but you're not going to get this nice summarized view
that you get in a pivot table.
All right, one other thing that you can do in Sheets,
which is nice, let's take off the ship mode.
And let's say you wanted to look at
office supplies and technology together.
You could highlight both of them,
right click and create a pivot table group,
where you could look at office supplies are 11,000
and furniture is 23,000.
That works easily in a pivot table,
not so much in Notion.
So let's take this group back out
and then we'll do something
where Notion does it completely differently.
And maybe it is better.
So let's take category out.
We're going to look at this by date.
And Google Sheets does summarize the total by date
which is what we asked it to.
And if you right click, you can do pivot date groups.
So let's say we want to show this by month.
Sheets organizes by month and gives you a total.
So that works fine until you come over to Notion
and see what Notion can do.
And this could be much more useful
depending on what you want to do.
There's two views in Notion.
One is called the timeline view
and it puts each of these records on a linear timeline
and then adds some data to the right of them,
which you can customize what it shows
and what the length of the timeline is.
So let's say we want to do it by month.
It's going to make it shorter.
If you want to do it by week,
it's going to stretch it out.
And you can just move things around the change
into different dates.
So that's super handy.
And there isn't the same type of summary that Sheets offers,
but could be better depending on what you're doing,
left click on timeline view,
and they also have something called a calendar view.
And that just puts these records on the day
that they belong to.
And when we left click on one of them,
it brings up all the relevant information for that record.
(upbeat music)
All right, like we talked about before,
if you want to see more information
on how to build good pivot tables in Google Sheets,
check out this next video.
Thanks for watching.