Unable to show recent data if entering at the same day

[BreadMilk]

I'm entering data from Forms > Sheets > Looker Studio. I'm showing the data with table. So, I enter data, and the data correctly shows up on the table. But, if I enter another data, it won't show the recent one. I need to show the data in one row only. This only happens if I enter on the same day. No problem if the next day.

If you can see the first image, number 1 is the most recent data.

But in the second image, if I show one number of rows, it will only show the old data. I've already sort it to descending order.

Can anyone help?

I've tried to refresh the data, data aggregation has not been set to min/ max an

[lauratilton · Accepted solution]

The Forms timestamp includes Date and Time, not just Date. Looks like you’ve changed the granularity so it is displaying Date only, so when you sort on that same field it’s not taking the time into account. I think if you change the granularity on the sort, this will act as you intend. 

[BreadMilk]

Thanks Laura, that fixed it! 😊