Get the value difference between today and yesterday

Get Help
1

Screen Shot 2023-03-05 at 6.40.40 PM
Screen Shot 2023-03-05 at 6.40.40 PM786×918 123 KB

I have a datasheet as follows but I don't know how to write to compare the different values between yesterday and today. For example, I need to know what the growth of today is? In math we will use growth today - growth yesterday
Ex Today Weight = 129M, Yesterday = 128m >> Growth Today = 129-128 = 1M.
I tried to write the Between expression but it was not effective. Between ([Weight], "Interval '1 Day'," Interval '-1 Day' ")) and a few other similar formulas.

Screen Shot 2023-03-05 at 6.46.12 PM
Screen Shot 2023-03-05 at 6.46.12 PM1712×726 104 KB

In addition, I also tried to create a metric including Max Weight Today and Max Weight Yesterday and then add it to the custom expression (Today - Yesterday) but it did not show the results

Screen Shot 2023-03-05 at 6.45.44 PM
Screen Shot 2023-03-05 at 6.45.44 PM2146×856 99.2 KB

2

you need to do a window function there but it's still not supported via GUI, please upvote Sliding windows in MBQL · Issue #9393 · metabase/metabase · GitHub

your only option is to do a SQL question