select
brand as brand,
count(case when status = 1 then 1 else 0 end) as pass,
count() as total
from $table
where
$timeFilter
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
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.
