| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| dayoperacao | Dia de Operação | STRING | ||||
| company | None | STRING | ||||
| chargeday | None | DATETIME | ||||
| projectminihash | None | STRING | ||||
| efciencia | None | INT |
| Table Name | Leonardo Bernardinelli-Untitled Query 2-duoAEMKq4 |
|---|---|
| Sql | select company ,chargeday ,projectminihash ,case when sum(planejado) is null then 0 else (100*sum(monitorado)/sum(planejado)) end as efciencia ,cast(substring(chargeday,9,2)||'-'||substring(chargeday,6,2)||'-'||substring(chargeday,1,4) as varchar(10)) as dayoperacao from eficiencia group by projectminihash, company, chargeday |
| 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-duoAEMKq4](id:285) |
| Associated Charts | [Eficiência por Grupo de Veículos] |