The last value mechanism is sort by character rather than timestamp by the transform group by

  • What Grafana version and what operating system are you using?
    grafana v8.5.5

  • What are you trying to achieve?
    I try to display the job newest status in the table line.

  • How are you trying to achieve it?
    The data source is loki. I have some log lines from the syslog and I use the query {job="app"}|pattern "<_>HPCTRACE: <_>: <_>: <message>"|line_format "{{.message}}"
    and choose the last value for the message by the group by in transform.

  • What happened?
    the message is not correct, because it is sort by the character rather than time stamp order.

  • What did you expect to happen?
    I want to display the last one message by timestamp order.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors

  • Did you follow any online instructions? If so, what is the URL?
    Transform data | Grafana documentation

A screenshot and some examples would probably help.