Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date time field (update_time) I'm pulling that has the following format:
2021-08-13 23:59:53.855000+00:00
I need to get the max of this field in a KPI
When I do Timestamp#(update_time,'YYYY-MM-DD hh:mm:ss.ffffff') as update_time, the field displays in the table but max(update_time) shows null
When I do Timestamp(Timestamp#(update_time,'YYYY-MM-DD hh:mm:ss.ffffff')) as update_time, all values in the field show as null and don't appear on the table and I'm unable to use the max function on it obviously
How can I render the field properly so that it shows max of it
@Panv try below
Timestamp(Timestamp#(subfield(update_time,'+',1),'YYYY-MM-DD hh:mm:ss[.ffffff]')) as new_update_time
@Panv try below
Timestamp(Timestamp#(subfield(update_time,'+',1),'YYYY-MM-DD hh:mm:ss[.ffffff]')) as new_update_time
Ahh great, ty!! I didnt realize the +00 needed to be removed, thought it will be part of timestamp format.
thanks a lot!