Requirement to get data from another row based on previous day with given date

[itsmeshankar1]

I have a table where similar data gets pulled in every day. I am in need of getting a graph which represents difference between today's and previous day data ( so 0, if previous date doesnt exist). 

Idea in my mind is to pull previous day data from previous day row and substract with current row data, put it in another column (+/-), present a graph based on that column.

First 3 column exist, I need to generate DiffFromPreviousDay, how do I do it?

Project	date	Numbers	DiffFromPreviousDay
a	28/04/2020	10	0
b	28/04/2020	21	0
c	28/04/2020	23	0
d	28/04/2020	21	0
e	28/04/2020	22	0
a	29/04/2020	10	0
b	29/04/2020	22	1
c	29/04/2020	23	0
d	29/04/2020	20	-1
e	29/04/2020	22	0

[MarcoPessina · Accepted solution]

Hi @itsmeshankar1 ,

try this sample out:

https://drive.google.com/file/d/1mQERw_bnJPVmo2-mqtY_aT_6RfBTEbuC/view

Hope it helps.

Cheers,

Marco