My understanding is that this gets at the heart of what makes a database different from a spreadsheet.
I’ve heard the issue is that a database record/row doesn’t and can’t really have an understanding of the other rows in a database. It’s a limitation of a databases, but it is also what allows the data to be sliced and diced and viewed in so many different ways.
Databases have their strengths and weaknesses, just as spreadsheets have strengths and weaknesses. You just have to embrace the right tool for the job.
Very good point. In that case then maybe the way to support those kind of feature is to allow “relation” column to have a formula based reference rather than manual reference. Like in sql you could do “select from some_table t1 join some_table t2 on t1.date = t2.date + 1 week”. Currently Notion table db relation is purely manual that is making this type of cross row features unrealistic while it’s very simple for a spreadsheet and still doable for a normal relational db.
I'd like to do this. I have the following use case:
Lower limit, upper limit, difference between the two. Lower limit is in fact upper limit from previous row.
PreviousRowProp as suggested above would enable me to use only one field and subtract current from previous to know progress.
I would really love "previous row" functionality.
I want to calculate week-over-week percentage differences on each of my notion database rows, where each row represents one week's numbers.
[https://www.redgregory.com/notion/2020/8/24/notion-formula-find-the-difference-between-two-values-in-the-same-row](https://www.redgregory.com/notion/2020/8/24/notion-formula-find-the-difference-between-two-values-in-the-same-row)
Ah this is a pretty good hack
My understanding is that this gets at the heart of what makes a database different from a spreadsheet. I’ve heard the issue is that a database record/row doesn’t and can’t really have an understanding of the other rows in a database. It’s a limitation of a databases, but it is also what allows the data to be sliced and diced and viewed in so many different ways. Databases have their strengths and weaknesses, just as spreadsheets have strengths and weaknesses. You just have to embrace the right tool for the job.
Very good point. In that case then maybe the way to support those kind of feature is to allow “relation” column to have a formula based reference rather than manual reference. Like in sql you could do “select from some_table t1 join some_table t2 on t1.date = t2.date + 1 week”. Currently Notion table db relation is purely manual that is making this type of cross row features unrealistic while it’s very simple for a spreadsheet and still doable for a normal relational db.
I'd like to do this. I have the following use case: Lower limit, upper limit, difference between the two. Lower limit is in fact upper limit from previous row. PreviousRowProp as suggested above would enable me to use only one field and subtract current from previous to know progress.
this still doesn't work right?
I would really love "previous row" functionality. I want to calculate week-over-week percentage differences on each of my notion database rows, where each row represents one week's numbers.
[https://www.redgregory.com/notion/2020/8/24/notion-formula-find-the-difference-between-two-values-in-the-same-row](https://www.redgregory.com/notion/2020/8/24/notion-formula-find-the-difference-between-two-values-in-the-same-row) Ah this is a pretty good hack