Since the features of transformations was been introduced, now it’s possible, you can try playing arround with Grafana transformations, using the original question about the AP’s three column table information, you could do three queries, one for each column and use this transformation recipe:
- Prepare time series with Format “Multi-frame time series”
- Reduce with Mode “Reduce” and Calculations “Last *”
- Labels to fields with Mode “Columns” and Labels in “host” e “item”
- Merge
- Organize fields to rename the columns the way you want to show it.
After that you can play arround with some Overrides, like in the image bellow:
