Show Chart

Owners [admin user]
Created By admin user
Changed By admin user
Created On 2023-02-13 09:12:27.414328
Changed On 2023-02-13 11:26:06.437928
Name Totale vs Totale Pagato
Datasource Id 23
Datasource Type table
Datasource Name public.fascicolo_financial_data-Q8Oe9NXVc
Visualization Type dual_line
Parameters { "adhoc_filters": [], "annotation_layers": [], "color_scheme": "SUPERSET_DEFAULT", "datasource": "23__table", "granularity_sqla": "data_fattura", "label_colors": { "A.M.B. MARMI E GRANITI SRL": "#00ffeb", "AL TRASPORTI": "#b4a76c", "ALDO FOIS COSTRUZIONI SRL": "#8ce071", "ALGHERO ITTICA SOC.COOP.": "#bbedab", "AP LOGISTICA SRL ex COMET": "#55d12e", "API S.p.A.": "#b4a76c", "AR.PLAST SRL": "#7b0051", "AUTOCARROZZERIA C.F di Fabio Giov.Romolo Chiesa": "#ff8083", "AUTOFFICINA BERNARDINI TONINO": "#ff5a5f", "AUTOMAR SERVICE SAS DI ZAZZARA": "#cc0086", "AUTOTRASPORTI DEMONTIS S.R.L.": "#00b3a5", "AUTOTRASPORTI GHIGLIONE GIANCARLO": "#007A87", "AYIMAM INDUSTRY di Sebastien Roger Ayimambenwe": "#007A87", "B.E.S.T SRL": "#005c66", "BIOIKOS S.r.l.": "#007A87", "BIOLOGICA SRL": "#55d12e", "BPA ENERGIA SRL": "#bbedab", "BRT S.P.A.": "#00b3a5", "BUTANGAS SPA": "#ff8083", "C.P.G Lab SRL": "#8ce071", "CALCESTRUZZI MEJLOGU SRL": "#005c66", "CAR SERVICE": "#b4a76c", "CAR.MET. SRL": "#00b3a5", "CERMELLI SRL": "#007A87", "CHELAB SRL": "#988b4e", "CIM SRL": "#b4a76c", "CIMA Srl": "#55d12e", "CO.MI SRL": "#55d12e", "COMAD ELETROMECCANICA S.N.C": "#ffd266", "D.I.M.A INFISSI": "#988b4e", "DASARA TRASPORTI S.P.A.": "#005c66", "DEMOLTORRES SNC DI BUSIA": "#ff1ab1", "DLR AMBIENTE SOC.COOP ARL": "#8ce071", "E' AMBIENTE IMPIANTI SRL": "#00d1c1", "ECO OPERA SRLS": "#cc0086", "ECOPRAMAL S.R.L.": "#00d1c1", "EKOSISTEMS SRL": "#8ce071", "ELIWIND SARDINIA SRL": "#b37e00", "EMMEGI SAS di Margherita Serra": "#ffb400", "ENAS": "#ff3339", "ENI SPA - REFINING E MARKETING": "#7b0051", "EUROMETAL S.R.L.": "#ff3339", "EUROPA SERVIZI ECO RIFIUTI SRL": "#00d1c1", "F.LLI MANGATIA di POSADINO EMANUELE & C. SAS": "#ff5a5f", "FALEGNAMERIA DEL PONTE SAS": "#ff3339", "FE.NI.CA S.A.S. di Sonia Chessa & C.": "#ff3339", "GECCOS SNC": "#bbedab", "GIMA SOC.COOP. SOACIALE ARL": "#7b0051", "GREEN WORLD THINKING S.R.L.": "#cc0086", "IL FARO SRL": "#00b3a5", "IMMOBILIARE IL BOSCO": "#cbc29a", "IMPREMARE SRL": "#007A87", "IMPRESA COMPAGNIA PORTUALE PORTO TORRES SRL": "#bbedab", "ISOLEX SCPA": "#00a1b3", "LA GRAFICA SRL": "#ffb400", "LEONI AMBIENTE SRL": "#ffd266", "LILIUMARINE DI FABRIZIO CUSUMANO": "#00a1b3", "LIQUIGAS SPA": "#cbc29a", "M.K.AUTOTRASPORTI CONTO TERZI": "#00d1c1", "MAD SNC di MAMELI ADRIANA": "#ffd266", "MARMO.IT di Arnaldo Melissa": "#ffb400", "MATRICA SPA": "#00d1c1", "MOBILCASA SRL": "#ff1ab1", "MOVISTRADE COGEFI S.r.l.": "#ff5a5f", "MURA PREFABBRICATI SRL": "#cbc29a", "NIVEA SPA": "#8ce071", "NOBENTO SPA": "#007A87", "NUOVA SISMET SRL": "#55d12e", "OFFICINA MARIO LELLA SRL": "#bbedab", "OFFICINA PELLATI FELICE SNC": "#cbc29a", "OFFICINE PORTO TORRES S.R.L.": "#988b4e", "OLEIFICIO SAN MARCO DI SALARIS GB & C": "#ffd266", "OLEODINAMICA PIANA SRL": "#00a1b3", "ON TECNOLOGY SRL": "#ffd266", "ORTU SRL": "#00ffeb", "PREMIX": "#ff3339", "RIT di Spanu F&C snc": "#8ce071", "S.M.C. SRLS Sarda Metalmeccanica Costruzioni": "#ff8083", "SABBIATURE INDUSTRIALI - SAIND SRL": "#00ffeb", "SAFISARDA SRL": "#00b3a5", "SANNA MARMI DI SANNA GIUSEPPE": "#988b4e", "SAPIO PRODUZIONE OSSIGENO SRL": "#ff5a5f", "SARDA ANTINQUINAMENTO SRL": "#7b0051", "SARDA CHIMICA SOCIETA' COOPERATIVA SOCIALE A.R.L.": "#b37e00", "SARDA ROTTAMI SRL": "#cc0086", "SARDA TEGOLE SRL": "#7b0051", "SARDINIA GLOBAL SERVICE SRL": "#ffb400", "SCA.MO.TER COSTRUZIONI SRL": "#00ffeb", "SER.TEC SRL": "#00d1c1", "SERVIZI COSTRUZIONI IMPIANTISTICA - SER.CO.IN SRL": "#b4a76c", "SERVIZI MARITTIMI SRL - SER.MAR SRL": "#ffb400", "SGS AUTOMAZIONE SRL": "#ff1ab1", "SIAD SPA": "#00a1b3", "SIMULA ALESSIO": "#00a1b3", "SWISS PACK MEDITERRANEA SRL": "#ff5a5f", "Sergio Cossu": "#ffb400", "T.M.S SRL": "#005c66", "TECNOCHIMICA SRL": "#00ffeb", "TELECOM ITALIA SPA": "#b37e00", "TORREFAZIONE MORGAN": "#005c66", "TOTAL CAR SRL (in locaz)": "#b37e00", "TRASCARGI SRL": "#ff1ab1", "TURRA SRL": "#b37e00", "TURRIS MARKET SRL": "#b4a76c", "TURRIS SLEEVE": "#988b4e", "Turrismarket S.r.l.": "#ff8083", "UNICALCESTRUZZI SPA": "#ff8083", "UNICALCESTRUZZI SPA (ENNEBI CALCESTRUZZI)": "#cc0086", "VERDE VITA": "#ff1ab1", "VERSALIS SPA": "#ff5a5f", "VIABILA SRL": "#cbc29a", "VITTORIO PINNA": "#7b0051" }, "metric": { "aggregate": "SUM", "column": { "column_name": "totale_fattura", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 392, "is_dttm": false, "optionName": "_col_totale_fattura", "type": "FLOAT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Totale", "optionName": "metric_scxsdazbkj_vs897560gq", "sqlExpression": null }, "metric_2": { "aggregate": "SUM", "column": { "column_name": "totale_pagato", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 394, "is_dttm": false, "optionName": "_col_totale_pagato", "type": "FLOAT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Pagato", "optionName": "metric_131cp317yzoc_tphg507bgo", "sqlExpression": null }, "slice_id": 35, "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "url_params": { "preselect_filters": "{\"39\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "dual_line", "x_axis_format": "%d/%m/%Y", "y_axis_2_format": ".1s", "y_axis_format": ".1s" }
Description None
Cache Timeout None
Perm [cips_forniture].[fascicolo_financial_data-Q8Oe9NXVc](id:23)
Schema Perm [cips_forniture].[public]
Dashboards []
Email Schedules []