| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| sum | None | None | ||||
| partita_iva | None | STRING | ||||
| descrizione | None | STRING | ||||
| ateco_codici | None | STRING |
| Table Name | admin user-Query admin user-Untitled Query 2-5Urrlb3-K-Na5MMEMRI |
|---|---|
| Sql | select sum(tabcont.media), tabcont.partita_iva, vv_sup_dip_ateco.descrizione, vv_sup_dip_ateco.ateco_codici from (select (coalesce(numerodip, '0')::decimal/count(*)::decimal)::decimal as media, numerodip, count(*), partita_iva from vv_sup_dip_ateco where numerodip<>'null' group by partita_iva, numerodip) tabcont left join vv_sup_dip_ateco on tabcont.partita_iva = vv_sup_dip_ateco.partita_iva group by tabcont.partita_iva, vv_sup_dip_ateco.descrizione, vv_sup_dip_ateco.ateco_codici |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | fascicoloimprese |
| Schema | None |
| 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-Query admin user-Untitled Query 2-5Urrlb3-K-Na5MMEMRI](id:58) |
| Associated Charts | [] |