I have a dataset which appends updated content data on a daily basis (with a 1 day reporting lag). I want to have the table show the latest data, however am struggling to do so. I tried filtering by last 2 days, which works most of the day until 7 PM CT, when everything is filtered out because I guess the filter is going by UTC time.
Is there a best practice for this?
Here's the concept.... if this is the existing data, I want to only show the data corresponding to the latest data: 9/28/21.
Date (day) -- Widget -- X -- Y
9/27/21 -- Wrench -- 2.4 -- $5
9/27/21 -- Hammer -- 5.1 -- $2
9/28/21 -- Wrench -- 2.7 -- $5.20
9/28/21 -- Hammer -- 4.7 -- $2.71