Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a column with timestamps and another column of values. I am looking to determine the maximum Value between the last (max) Timestamp and 24 hours ago. I am having trouble writing an expression for this. Can you please help? Thank you.
Although you can try something like this
Max({<TimeStampField = {">=$(=TimeStamp(Max(TimeStampField) - 1, 'TimeStampFieldFormatHere'))<=$(=TimeStamp(Max(TimeStampField), 'TimeStampFieldFormatHere'))"}>} Value)
What have you tried so far? Can you share some sample data and the output expected from it?
Although you can try something like this
Max({<TimeStampField = {">=$(=TimeStamp(Max(TimeStampField) - 1, 'TimeStampFieldFormatHere'))<=$(=TimeStamp(Max(TimeStampField), 'TimeStampFieldFormatHere'))"}>} Value)