Lost values after Grouping to Matrix

[radekb]

Hello,
I’m new to Grafana so maybe I just misunderstand something but I’ve got a problem.
I want to create a matrix using 3 types of values (x,y,z).
I am using Grouping to Matrix transformation and I’m using x for Column, y for Row and z for Cell value. In my scenario I have multiple z for the same x and y ex:
|Column 1 | Column 2 | Column 3 | Column 4|

|— | — | — |
|x1 | y1 | z1 |
|x1 | y1 | z2 |
|x1 | y1 | z3 |

But in the matrix for x1 and y1 only one z value (most recent) is shown.
|column/row | y1|
|x1 | z1|
I would like to have in the cell for x1 an y1 shown z1 z2 and z3 values.
|column/row | y1|
|x1 | z1,z2,z3|
is it possible and if so how?

[vijha1989]

Looks like I am encountering the same issue, I am wondering if you were able to solve it?

I am trying to show a pod’s state change over time.

Data outputs this in tabular format:

Applied Grouping to Matrix and Convert field type matrix:

[yosiasz]

depends, what is your datasource

[vijha1989]

The source is Prometheus. I’ve deployed a Minikube cluster, trying to create some dashboards based on Kubernetes Metrics.

Grafana Version: Grafana v11.1.0

[yosiasz]

sorry @vijha1989 question was for original poster

[ebabeshko]

@radekb

is it possible and if so how?

The best way would be to use datasource capabilities.

But if it can’t be sorted by datasource, try to apply Group by transformation before Grouping to Matrix.

Example of initial data:

Example of result after two transformations:

[yosiasz]

does that datasource provide a means of collapsing rows into one row and allow concatenating of row values?
for example in ms sql