| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| id | None | INT | ||||
| category | None | STRING | ||||
| projectminihash | None | STRING | ||||
| route | Linha | STRING | ||||
| day | None | DATETIME | ||||
| vehicle | None | STRING | ||||
| agency | None | STRING | ||||
| timerange | None | INT | ||||
| month | None | STRING | ||||
| year | None | INT | ||||
| tripname | Viagem | STRING | ||||
| monitored_start_time | None | DATETIME | ||||
| monitored_arrival_time | None | DATETIME | ||||
| planned_start_time | None | DATETIME | ||||
| planned_arrival_time | None | DATETIME | ||||
| planned_trip_duration | None | INT | ||||
| monitored_trip_duration | None | INT |
| Table Name | Leonardo Bernardinelli-Untitled Query 2-qlb3X2rS- |
|---|---|
| Sql | select * from tripduration |
| 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-qlb3X2rS-](id:480) |
| Associated Charts | [Duração Média da Viagem] |