How to create a table with single value for a host and metric

[walterlharris]

• What are you trying to achieve?
  I have a table with a transform to add multiple fields. The table includes a time series for several hosts and disk metrics. I only want to show the most recent time series data for each host/disk metrics but it displays every time series for each host.

• How are you trying to achieve it?
  I am using a label to field transform.

Here is a screenshot:

[jangaraj]

@walterlharris

only want to show the most recent time series data for each host/disk metrics

why you don’t query only last value? It is a wasting of resources to return last 6 hours and then drop majority of the query results on the Grafana side