Tabel panel in grafana


Having this query

     brand as brand,
     count(case when status = 1 then 1 else 0 end) as pass,
     count() as total
     from $table
     group by brand
     order by pass , total desc

I expected table with 3 columns but it create table with 2 columns, one named time and other have option to select total/pass

Could you please help me to figure out what is wrong?

Try using a outer join transform function.

Demonstration table without transform

Demonstration table with transform

I hope this helps

1 Like

Is there an option to rename column name?

How about using a simple Override? See example below (Override 6) where I renamed Memory as Gigaflops. Instead of Test 1 (or Test 2), you would write your desired name in the Override.