Solved: Display only the last Value - Page 2

AbdullaNsour · 01-24-2024 12:54 AM

Hello AppSheet community,

I am working on a health monitoring app, specifically for diabetic patients. In my app, I have a table named Test with columns such as Date and Average , representing the date and average values for each day.

I want to display only today's last average value on the app instead of all values

I appreciate any assistance or insights. Thank you!

Markus_Malessa

Try the below. However, since I see that you also have a User reference I am wondering if you need any filtering specific to the user also. Just something to consider.

LOOKUP(MAXROW(Test[Test_ID],[Timestamp]),"Test","Test_ID","Average")

View solution in original post