This message was deleted.

Hi Pavithra, I'm not sure I understand exactly what you are trying to do ... if by "raw value" you mean you have an integer value representing (Unix) time, then you can do a min() on that value within the group, and apply a conversion function like MILLIS_TO_TIMESTAMP() to display it in timestamp format. Is that what you were looking for? E.g. here I am testing out some operations on the wikipedia datasource ... I don't have a secondary (integer) time field, but I converted __time to an integer so I could apply the min() function

select channel, MILLIS_TO_TIMESTAMP(min(TIMESTAMP_TO_MILLIS(__time))) from wikipedia group by 1

It would really help if you provided an example. Like a table with 3 or 4 rows and what your minimum actual time calculation you want to see come out of that