Geomap - use different color for last table value

Grafana
,
1

  • What Grafana version and what operating system are you using?
    8.2.5

  • What are you trying to achieve?
    I am able to visualize on geomap the location data (lat, long) from a table (by time), but I am not able to color the last location with a different color.
    See the image.
    immagine

  • How are you trying to achieve it?
    I also duplicated the query, set LIMIT = 1 and colorized the single event, but in this attempt I cannot visualize both query results at the same time.

  • What happened?
    I am able to show all the positions but cannot color the last event.

  • What did you expect to happen?
    I want the last position to be colored differently from others.

  • Can you copy/paste the configuration(s) that you are having problems with?
    SELECT last(“Latitude”), last(“Longitude”) FROM “state” WHERE (“entity_id” = ‘sm_n975f_posizione_geocodificata’) AND time >= now() - 3d and time <= now() GROUP BY time(5m) fill(none)

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

  • Did you follow any online instructions? If so, what is the URL?
    No tips related to this.