| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| somma | None | None | ||||
| partita_iva | None | STRING | ||||
| descrizione | None | STRING | ||||
| ateco_codici | None | STRING | ||||
| codice_ateco | None | STRING |
| Table Name | admin user-Query admin user-Untitled Query 2-5Urrlb3-K-NXkPmltRt |
|---|---|
| Sql | select * from( select sum(tabcont.media) as somma, tabcont.partita_iva, vv_sup_dip_ateco.descrizione, vv_sup_dip_ateco.ateco_codici , vv_sup_dip_ateco.codice_ateco 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, vv_sup_dip_ateco.codice_ateco)a where somma>0 |
| 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 | [fascicoloimprese].[admin user-Query admin user-Untitled Query 2-5Urrlb3-K-NXkPmltRt](id:61) |
| Associated Charts | [Codici Ateco/ Numero Dipendenti, Codici Ateco/ Numero Dipendenti] |