Show Table

Column Verbose Name Type Groupable Filterable Is temporal
day None DATETIME
rn Linha STRING
trip_headsign Viagem STRING
dt Horário STRING
monitorado Monitorado STRING
project_id None STRING
dayoperacao Dia STRING
daytimeoperation None TIMESTAMP
extra Extra STRING
Record Count: 9
Metric Verbose Name Type
count None None
Record Count: 1
Table Name Leonardo Bernardinelli-Untitled Query 3-5XrkR-aI_
Sql select day ,rn ,trip_headsign ,dt ,case when executado is not null then 'SIM' else 'NÃO' end monitorado ,project_id ,cast(substring(day,9,2)||'-'||substring(day,6,2)||'-'||substring(day,1,4) as varchar(10)) as dayoperacao ,cast(day||' '||dt as timestamp) as daytimeoperation ,case when tabela = 88 then 'SIM' else 'NÃO' end extra from eficienciaporlinhacomviagemextra
Enable Filter Select False
Fetch Values Predicate None
Database realtime_db
Schema public
Description None
Owners [Leonardo Bernardinelli]
Main Datetime Column None
Default Endpoint None
Offset 0
Cache Timeout None
SQL Lab View True
Template parameters None
Perm [realtime_db].[Leonardo Bernardinelli-Untitled Query 3-5XrkR-aI_](id:148)
Associated Charts [Eficiência por Linha]