Concatenate two numerical values in a table

[jasz]

I’m using Grafana v10.4.2.

I have two PromQL queries, one gets me the number of active pods, the other the expected number of pods. I’ve selected type=instant and format=table for both. I’ve also used the “Merge series/tables” transformation and now my table looks something like this:

Service	Active pods	Expected pods
service-a	2	2
service-b	1	2

I want to concatenate the last two columns so that it looks like this:

Service	Pods
service-a	2/2
service-b	1/2

I tried to use the “Add field from calculation” transformation, but there’s no concatenation there. I also tried to change the type of the fields to strings first, but that didn’t seem to have any effect.

Is this possible? Thanks!

[ebabeshko]

@jasz

Is this possible?

You can get comma-separated values for each row if you choose All values in that transformation:

How to create a new column using another two column values

What is your datasource? It would be more appropriate to do it by its means. Using Grafana’s transformation the closiest you can achieve is something like this: [new column]