Show Chart

Owners [admin user]
Created By admin user
Changed By admin user
Created On 2023-02-13 10:15:36.807220
Changed On 2023-03-28 09:30:47.381540
Name Fatture nel tempo
Datasource Id 28
Datasource Type table
Datasource Name public.Query public.fascicolo_financial_data-nlRcIzTT1-5cdo5RG15
Visualization Type bar
Parameters { "adhoc_filters": [], "annotation_layers": [], "bar_stacked": true, "bottom_margin": "auto", "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "28__table", "granularity_sqla": "data_fattura", "groupby": [ "ragione_sociale", "zona" ], "label_colors": { "201": "#ffb400", "2332": "#ff5a5f", "4941": "#7b0051", "522209": "#b4a76c", "6201": "#007A87", "749": "#00d1c1", "8121": "#8ce071", "85592": "#ff8083", "A.M.B. MARMI E GRANITI SRL": "#ff5a5f", "AL TRASPORTI": "#007A87", "ALDO FOIS COSTRUZIONI SRL": "#00b3a5", "ALGHERO ITTICA SOC.COOP.": "#b4a76c", "AP LOGISTICA SRL ex COMET": "#988b4e", "API S.p.A.": "#988b4e", "AR.PLAST SRL": "#55d12e", "AUTOCARROZZERIA C.F di Fabio Giov.Romolo Chiesa": "#00d1c1", "AUTOFFICINA BERNARDINI TONINO": "#00b3a5", "AUTOMAR SERVICE SAS DI ZAZZARA": "#8ce071", "AUTOTRASPORTI DEMONTIS S.R.L.": "#ff8083", "AUTOTRASPORTI GHIGLIONE GIANCARLO": "#b37e00", "AYIMAM INDUSTRY di Sebastien Roger Ayimambenwe": "#bbedab", "Alghero San Marco": "#00ffeb", "B.E.S.T SRL": "#ff1ab1", "BIOIKOS S.r.l.": "#ff5a5f", "BIOLOGICA SRL": "#00b3a5", "BPA ENERGIA SRL": "#bbedab", "BRT S.P.A.": "#55d12e", "BUTANGAS SPA": "#005c66", "C.P.G Lab SRL": "#ff5a5f", "CALCESTRUZZI MEJLOGU SRL": "#ff1ab1", "CAR SERVICE": "#ff1ab1", "CAR.MET. SRL": "#bbedab", "CERMELLI SRL": "#8ce071", "CHELAB SRL": "#005c66", "CIM SRL": "#ff8083", "CIMA Srl": "#ffd266", "CO.MI SRL": "#ff3339", "COMAD ELETROMECCANICA S.N.C": "#ff8083", "D.I.M.A INFISSI": "#cc0086", "DASARA TRASPORTI S.P.A.": "#005c66", "DEMOLTORRES SNC DI BUSIA": "#cbc29a", "DLR AMBIENTE SOC.COOP ARL": "#cbc29a", "E' AMBIENTE IMPIANTI SRL": "#cc0086", "ECO OPERA SRLS": "#ff3339", "ECOPRAMAL S.R.L.": "#988b4e", "EKOSISTEMS SRL": "#7b0051", "ELIWIND SARDINIA SRL": "#55d12e", "EMMEGI SAS di Margherita Serra": "#55d12e", "ENAS": "#ffd266", "ENI SPA - REFINING E MARKETING": "#ff3339", "EUROMETAL S.R.L.": "#cbc29a", "EUROPA SERVIZI ECO RIFIUTI SRL": "#ffb400", "F.LLI MANGATIA di POSADINO EMANUELE & C. SAS": "#cbc29a", "FALEGNAMERIA DEL PONTE SAS": "#00a1b3", "FE.NI.CA S.A.S. di Sonia Chessa & C.": "#00a1b3", "GECCOS SNC": "#7b0051", "GIMA SOC.COOP. SOACIALE ARL": "#ffb400", "GREEN WORLD THINKING S.R.L.": "#00d1c1", "IL FARO SRL": "#b4a76c", "IMMOBILIARE IL BOSCO": "#cc0086", "IMPREMARE SRL": "#005c66", "IMPRESA COMPAGNIA PORTUALE PORTO TORRES SRL": "#b4a76c", "LA GRAFICA SRL": "#ff3339", "LEONI AMBIENTE SRL": "#cc0086", "LILIUMARINE DI FABRIZIO CUSUMANO": "#ffb400", "LIQUIGAS SPA": "#bbedab", "M.K.AUTOTRASPORTI CONTO TERZI": "#ffd266", "MAD SNC di MAMELI ADRIANA": "#007A87", "MARMO.IT di Arnaldo Melissa": "#7b0051", "MATRICA SPA": "#ff1ab1", "MOBILCASA SRL": "#8ce071", "MOVISTRADE COGEFI S.r.l.": "#988b4e", "MURA PREFABBRICATI SRL": "#00d1c1", "ND": "#00a1b3", "NIVEA SPA": "#55d12e", "NOBENTO SPA": "#cbc29a", "NUOVA SISMET SRL": "#ff3339", "OFFICINA MARIO LELLA SRL": "#ff8083", "OFFICINA PELLATI FELICE SNC": "#00ffeb", "OFFICINE PORTO TORRES S.R.L.": "#7b0051", "OLEIFICIO SAN MARCO DI SALARIS GB & C": "#b37e00", "OLEODINAMICA PIANA SRL": "#988b4e", "ON TECNOLOGY SRL": "#ffd266", "ORTU SRL": "#b4a76c", "PREMIX": "#007A87", "Porto Torres": "#cc0086", "RIT di Spanu F&C snc": "#7b0051", "S.M.C. SRLS Sarda Metalmeccanica Costruzioni": "#00d1c1", "SABBIATURE INDUSTRIALI - SAIND SRL": "#ffb400", "SAFISARDA SRL": "#005c66", "SANNA MARMI DI SANNA GIUSEPPE": "#b37e00", "SAPIO PRODUZIONE OSSIGENO SRL": "#007A87", "SARDA ANTINQUINAMENTO SRL": "#ff1ab1", "SARDA CHIMICA SOCIETA' COOPERATIVA SOCIALE A.R.L.": "#ff8083", "SARDA ROTTAMI SRL": "#b37e00", "SARDA TEGOLE SRL": "#00b3a5", "SCA.MO.TER COSTRUZIONI SRL": "#cc0086", "SER.TEC SRL": "#007A87", "SERVIZI COSTRUZIONI IMPIANTISTICA - SER.CO.IN SRL": "#00d1c1", "SERVIZI MARITTIMI SRL - SER.MAR SRL": "#b37e00", "SGS AUTOMAZIONE SRL": "#00ffeb", "SIAD SPA": "#8ce071", "SIMULA ALESSIO": "#8ce071", "SWISS PACK MEDITERRANEA SRL": "#00a1b3", "Sergio Cossu": "#b4a76c", "T.M.S SRL": "#cbc29a", "TECNOCHIMICA SRL": "#00b3a5", "TELECOM ITALIA SPA": "#ff3339", "TORREFAZIONE MORGAN": "#ffb400", "TOTAL CAR SRL (in locaz)": "#ff1ab1", "TRASCARGI SRL": "#bbedab", "TURRA SRL": "#ff5a5f", "TURRIS MARKET SRL": "#00ffeb", "Troncu Reale": "#bbedab", "Turrismarket S.r.l.": "#00a1b3", "UNICALCESTRUZZI SPA": "#00a1b3", "UNICALCESTRUZZI SPA (ENNEBI CALCESTRUZZI)": "#00ffeb", "VERDE VITA": "#ff5a5f", "VERSALIS SPA": "#ffd266", "VIABILA SRL": "#ffd266", "VITTORIO PINNA": "#00ffeb" }, "left_margin": "auto", "line_interpolation": "linear", "metrics": [ { "aggregate": "SUM", "column": { "column_name": "totale_fattura", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 424, "is_dttm": false, "optionName": "_col_totale_fattura", "type": "FLOAT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "SUM(totale_fattura)", "optionName": "metric_2k1c48cmo8t_urxju8ednri", "sqlExpression": null } ], "order_desc": true, "reduce_x_ticks": false, "resample_method": "bfill", "resample_rule": "1M", "rich_tooltip": true, "rolling_type": "None", "row_limit": 1000, "show_bar_value": true, "show_brush": "auto", "show_controls": false, "show_legend": false, "slice_id": 38, "time_grain_sqla": "P1Y", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "timeseries_limit_metric": { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "ragione_sociale", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 421, "is_dttm": false, "optionName": "_col_ragione_sociale", "type": "STRING", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "COUNT_DISTINCT(ragione_sociale)", "optionName": "metric_2c5yso7y2vm_td77cyxdd", "sqlExpression": null }, "url_params": { "preselect_filters": "{\"39\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "bar", "x_axis_format": "%Y-%m-%d", "x_axis_label": "", "x_axis_showminmax": false, "x_ticks_layout": "auto", "y_axis_bounds": [ null, null ], "y_axis_format": "$,.2f", "y_axis_label": "", "y_axis_showminmax": false, "y_log_scale": false }
Description None
Cache Timeout None
Perm [cips_forniture].[Query public.fascicolo_financial_data-nlRcIzTT1-5cdo5RG15](id:28)
Schema Perm [cips_forniture].[public]
Dashboards []
Email Schedules []