Table Panel Columns to Rows

Grafana PostgreSQL
1

Hi All,

Managed to queried this:

image
image1893×225 7.32 KB

With this query:

SELECT patchsession,
count(*) as Baseline,
COUNT (*) filter(where exempted='SKIP_L2_APPROVAL') AS SKIP_L2_APPROVAL
from patchtracking P, cycle C
where C.cyclename=$cyclename and P.patch_id=C.id 
group by patchsession

Is it possible to query it so that it display this:

                            UAT
------------               ----
Baseline                    78
Skipped with L2 Approval    14

Thanks,
HY

2 Likes
2

Hi. I am stuck in similar problem. You got any solution.

2 Likes
3

Any idea how to do this ?, We have a table which always ends up with one row , but with 50 columns
Can the columns become rows ?
we are using logs in Metric to pull all columns of the record

2 Likes
4

Same here. Need this functionality

1 Like
5

I need this one as well, any updates ?

6

Maybe unnest can help you. I use it with Crate.io and I think is the same with Postgre.

7

same situation here, I solved this by using transformation -> reduce ->mode: series to rows, calculation: total
This Example Dashboard helped me a lot figuring out whats going on in case anyone else struggles with this kind of basic cluelessness.

7 Likes
8

Thanks, Series to rows saved me as well when i wanted to display data in Bar Chart

9

great!