Understanding Transformation Function

[manish2501]

Hello All,

I have started using graffana recently and trying to create a dashboard. When I use the below query

sum by (status)(increase(custom_app_products_total{container="app",}[12h]))

I am getting the below result:

I want to show it in a table with status label’s value as column header.

I believe “Label To Field” can be used here but I am not very sure how to use it achieve the expected result. I have already gone through documentation but still not able to understand it’s behavior.

When I am using column mode with value field name as “status” I am getting below result but only for one status at a time:

How can I get all status with respective values ? Please suggest.

Thanks

[sowdenraymond]

in column mode, try using the concatenate fields transformation to join all your statuses

[manish2501]

@sowdenraymond

the concatenate fields transformation to join all your statuses

Tried that but it’s creating redundant column for Time along with status values. Also value for respective status is not aggregated.