| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| rn | Linha | STRING | ||||
| planejado | Planejado | INT | ||||
| porcentagem | Eficiência (%) | None | ||||
| executado | Monitorado | INT | ||||
| projectminihash | None | STRING | ||||
| atrasado | Atrasado | None | ||||
| porcentagematrasado | Atrasado (%) | None | ||||
| adiantado | Adiantado | None | ||||
| porcentagemadiantado | Adiantado (%) | None | ||||
| pontual | Pontual | None | ||||
| porcentagempontual | Pontual (%) | None | ||||
| dayoperacao | Data | STRING | ||||
| chargeday | None | DATETIME | ||||
| company | Operadora | STRING | ||||
| naomonitorado | Não Monitorado | None | ||||
| service | Serviço | STRING | ||||
| typeroute | Tipo de Linha | STRING |
| Table Name | Leonardo Bernardinelli-Untitled Query 2--HfSZpTix |
|---|---|
| Sql | select chargeday ,company ,service ,typeroute ,rn ,sum(planejado) as planejado ,cast(100* sum(monitorado) / sum(planejado) as numeric(19,2)) as porcentagem ,sum(monitorado) as executado ,sum(atrasado) as atrasado ,cast(100* sum(atrasado)/sum(monitorado) as numeric(19,2)) as porcentagematrasado ,sum(adiantado) as adiantado ,cast(100* sum(adiantado)/sum(monitorado) as numeric(19,2)) as porcentagemadiantado ,sum(pontual) as pontual ,cast(100* sum(pontual)/sum(monitorado) as numeric(19,2)) as porcentagempontual ,projectminihash ,cast(substring(chargeday,9,2)||'-'||substring(chargeday,6,2)||'-'||substring(chargeday,1,4) as varchar(10)) as dayoperacao ,cast(sum(planejado) - sum(monitorado) as numeric(19,12)) as naomonitorado from eficiencia group by chargeday,company,service,typeroute,rn,projectminihash |
| 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 2--HfSZpTix](id:171) |
| Associated Charts | [Eficiência Diária Tabela] |