Split Column in Table

[solcybersoc]

Hello! I have a Table panel, and I have used the following transformations

Which resulted in the following table:

Priority	Subtype	Count
High	Category 1	4
High	Category 2	3
High	Category 3	0
Medium	Category 1	0
Medium	Category 2	3
Medium	Category 3	7
Low	Category 1	4
Low	Category 2	1
Low	Category 3	2

My desired outcome is table that looks like this:

Priority	Category 1	Category 2	Category 3
High	4	3	0
Medium	0	3	7
Low	4	1	2

I cannot figure out how to do this. I have tried the “Partition by values” transformation, which creates separate tables I can view with the data per each subtype, but I want the data in one table or I guess a matrix is the correct term.

[yosiasz]

what is your datasource? mysql?

[solcybersoc]

InfluxDB

[yosiasz]

are you using flux or influxql query language?

[grant2]

And please share your query (or queries) and the results before you apply the transformations.

[solcybersoc]

Using InfluxQL.

Query: SELECT * FROM "tickets" WHERE $timeFilter

Results pre transformations:

There are the column headers. As you can assume I removed the actual data for privacy.

My first transform filters for only items with a specific ticket Type.
My second transform removes any unnecessary columns from view, leaving “priority” and “subtype”.

[solcybersoc]

Here’s a better image

[carlocea9]

It looks like what you’re after is a cross-tab table / matrix table / pivot table.

If you’re using the Grafana table visualization then there is very little support for this - refer to Github #105220.
You can use the “Grouping to Matrix” transformation but it is very much lacking.

You’re better off making a custom table using HTML / JS through a different plugin like Business Text.