Get Last Value by Distinct Name

Using Grafana 11.3 I’m currently getting the last_extraction for every connector I have into a table like so:

However I do not want to include thhe Invalid Dates and only keep distinct connectors connector_name. When using the Reduce - Last transformation I only get one row however of whichever connector has the most recent last_extraction.

Filtering out the invalids is easy enoug with a Filter data by values, however how do I get the latest last_extraction of every connector_name ?

You can use Group by transformation (I think).

Thanks you very much! That worked perfectly and I can also directly include Last* as a Calculaton.

1 Like