Column indexing for dynamic fields in Grafana Table (Prometheus)

Grafana Prometheus
1

Hi everyone,

I’m working with Prometheus data (exported from Excel) where column names and the number of columns vary across datasets. In Grafana Table panel, these become dynamic fields, and I’m unable to assign or maintain a consistent column index (like col1, col2, col3) since Grafana treats columns by field name rather than position.

Is there any way in Grafana to dynamically index columns regardless of changing field names/count? Or is handling column indexing at the exporter/data source level the only recommended approach?

Thanks!

2

hello @dfirake09 you can use Organize fields transformation and rename and reaggange it but it is limited not dynamic.
you can try
Instead of sending:
Name | Age | City
Send:
col1 | col2 | col3
And for another dataset:
col1 | col2 | col3 | col4
It only works with field names