Our podcast editor Chris was curious how to track changes in computer equipment pricing over time. Aggregation in Notion requires Relations. We can't do a lot without a relation in Notion which makes it not obvious how to model this type of change over time. If we're used to how spreadsheets work. Notion is technically different from spreadsheets!
Check out the walkthrough of this build below!
Here’s the data set supplied by Chris: .
I’m going to recreate my own as all I need to replicate this is a Name field (this is technically called a Title property).
In order to track things over time in Notion, we can’t just store the snapshot in the same database unless we want to add properties for each snapshot. This is where Relations come into play. So we will create a separate table that is related to Gaming Options called Pricing Options.
Below you can see each of the options is related to the ASUS ROG Strix G13 page and we have a Date for each Cost.
So we’ve created a snapshot of ASUS ROG Strix G13 for three different days. Now what?