| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| chargeday | None | DATETIME | ||||
| projectminihash | None | STRING | ||||
| rn | None | STRING | ||||
| company | None | STRING | ||||
| pontual | 4-Pontual | None | ||||
| atrasado | 8-Atrasado | None | ||||
| adiantado | 6-Adiantado | None | ||||
| extra | 10-Extra | None | ||||
| monitorado | 2-Monitorado | INT | ||||
| planejado | 1-Planejado | INT | ||||
| porcentagemmonitorado | 3-Eficiência (%) | INT | ||||
| porcentagematrasado | 9-Atrasado (%) | None | ||||
| porcentagemadiantado | 7-Adiantado (%) | None | ||||
| porcentagempontual | 5-Pontual (%) | None | ||||
| porcentagemextra | 10-Extra (%) | None | ||||
| dayoperacao | dayoperacao | STRING |
| Table Name | Leonardo Bernardinelli-Untitled Query 2-6mQ0VQ9az |
|---|---|
| Sql | select chargeday, projectminihash, rn, company, sum(pontual) as pontual, sum(atrasado) as atrasado, sum(adiantado) as adiantado, sum(extra) as extra, sum(monitorado) as monitorado, sum(planejado) as planejado, case when sum(planejado) = 0 then 0 else (100*sum(monitorado)/sum(planejado)) end as porcentagemmonitorado, case when sum(monitorado) = 0 then 0 else (100*sum(atrasado)/sum(monitorado)) end as porcentagematrasado, case when sum(monitorado) = 0 then 0 else (100*sum(adiantado)/sum(monitorado)) end as porcentagemadiantado, case when sum(monitorado) = 0 then 0 else (100*sum(pontual)/sum(monitorado)) end as porcentagempontual, case when sum(monitorado) = 0 then 0 else (100*sum(extra)/sum(monitorado)) end as porcentagemextra, cast(substring(chargeday,9,2)||'-'||substring(chargeday,6,2)||'-'||substring(chargeday,1,4) as varchar(10)) as dayoperacao from eficiencia group by chargeday,projectminihash,rn,company |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | realtime_db |
| Schema | None |
| 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-6mQ0VQ9az](id:261) |
| Associated Charts | [Relatório de Pontualidade - Gráfico] |