I am presently trying to make a report based on a snapshot thats taken 3 times a day. For eg.
8/8/2022 16.00
9/8/2022 8.00
9/8/2022 12.00
9/8/2022 16.00
What I want to return is, if its a snapshot of 16.00 today, to say "todays report", values from 9/8/2022 12.00 to say previous report or if the date is yesterday like 8/8/2022 to say "yesterdays report".
Cant seem to figure it out.
=IF([@snapshot]=MAX([snapshot]),"Today's report",IF([@snapshot]=MAX([snapshot])-1,"Previous report","Older report"))
Something like this is what I want and the snapshot column is in datetime format