| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| user_id | None | INT | ||||
| rowid | None | INT | ||||
| partita_iva | None | STRING | ||||
| totalValueOfProduction | None | STRING | ||||
| yearenddate | None | STRING |
| Table Name | admin user-financial_data_disgreg-cNy7vLbXE |
|---|---|
| Sql | select a.user_id , a.rowid, 'PARTITA IVA:'||a.partita_iva as partita_iva, a.valore_n as "totalValueOfProduction", b.valore_n as yearEndDate from (SELECT user_id , rowid, partita_iva ,campo, valore_n FROM v_financial_deaggr where campo in ('totalValueOfProduction') GROUP BY 1,2,3,4,5) a left join (SELECT user_id , rowid, partita_iva ,campo, valore_n FROM v_financial_deaggr where campo in ('yearEndDate') GROUP BY 1,2,3,4,5) b on a.user_id= b.user_id and a.partita_iva=b.partita_iva and a.rowid=b.rowid |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | fascicoloimprese |
| Schema | public |
| Description | None |
| Owners | [admin user] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | True |
| Template parameters | None |
| Perm | [None].[admin user-financial_data_disgreg-cNy7vLbXE](id:34) |
| Associated Charts | [Valore della produzione per anno] |