Superset

Edit Chart

Name
Description	The content here can be displayed as widget headers in the dashboard view. Supports markdown
Visualization Type
Owners
Dashboards
Parameters	{ "adhoc_filters": [], "bottom_margin": "auto", "color_scheme": "bnbColors", "datasource": "41__table", "entity": "yearenddate", "granularity_sqla": null, "label_colors": { "201": "#7b0051", "2332": "#b4a76c", "4941": "#8ce071", "522209": "#ffb400", "6201": "#007A87", "749": "#00d1c1", "8121": "#ff8083", "85592": "#cc0086", "A.M.B. MARMI E GRANITI SRL": "#b37e00", "AL TRASPORTI": "#ff1ab1", "ALDO FOIS COSTRUZIONI SRL": "#cbc29a", "ALGHERO ITTICA SOC.COOP.": "#988b4e", "AP LOGISTICA SRL ex COMET": "#b4a76c", "API S.p.A.": "#ff1ab1", "AR.PLAST SRL": "#00ffeb", "AUTOCARROZZERIA C.F di Fabio Giov.Romolo Chiesa": "#005c66", "AUTOFFICINA BERNARDINI TONINO": "#00a1b3", "AUTOMAR SERVICE SAS DI ZAZZARA": "#00b3a5", "AUTOTRASPORTI DEMONTIS S.R.L.": "#ffb400", "AUTOTRASPORTI GHIGLIONE GIANCARLO": "#bbedab", "AYIMAM INDUSTRY di Sebastien Roger Ayimambenwe": "#bbedab", "B.E.S.T SRL": "#8ce071", "BIOIKOS S.r.l.": "#bbedab", "BIOLOGICA SRL": "#b4a76c", "BPA ENERGIA SRL": "#988b4e", "BRT S.P.A.": "#ffb400", "BUTANGAS SPA": "#005c66", "C.P.G Lab SRL": "#cbc29a", "CALCESTRUZZI MEJLOGU SRL": "#8ce071", "CAR SERVICE": "#ff1ab1", "CAR.MET. SRL": "#ffb400", "CERMELLI SRL": "#bbedab", "CHELAB SRL": "#cc0086", "CIM SRL": "#ff1ab1", "CIMA Srl": "#b4a76c", "CO.MI SRL": "#b4a76c", "COMAD ELETROMECCANICA S.N.C": "#ff5a5f", "D.I.M.A INFISSI": "#cc0086", "DASARA TRASPORTI S.P.A.": "#8ce071", "DEMOLTORRES SNC DI BUSIA": "#00d1c1", "DLR AMBIENTE SOC.COOP ARL": "#cbc29a", "E' AMBIENTE IMPIANTI SRL": "#ffd266", "ECO OPERA SRLS": "#00b3a5", "ECOPRAMAL S.R.L.": "#ffd266", "EKOSISTEMS SRL": "#cbc29a", "ELIWIND SARDINIA SRL": "#ff8083", "EMMEGI SAS di Margherita Serra": "#ff3339", "ENAS": "#007A87", "ENI SPA - REFINING E MARKETING": "#00ffeb", "EUROMETAL S.R.L.": "#007A87", "EUROPA SERVIZI ECO RIFIUTI SRL": "#ffd266", "F.LLI MANGATIA di POSADINO EMANUELE & C. SAS": "#00a1b3", "FALEGNAMERIA DEL PONTE SAS": "#007A87", "FE.NI.CA S.A.S. di Sonia Chessa & C.": "#007A87", "GECCOS SNC": "#988b4e", "GIMA SOC.COOP. SOACIALE ARL": "#00ffeb", "GREEN WORLD THINKING S.R.L.": "#00b3a5", "IL FARO SRL": "#ffb400", "IMMOBILIARE IL BOSCO": "#7b0051", "IMPREMARE SRL": "#bbedab", "IMPRESA COMPAGNIA PORTUALE PORTO TORRES SRL": "#988b4e", "ISOLEX SCPA": "#55d12e", "LA GRAFICA SRL": "#ff3339", "LEONI AMBIENTE SRL": "#ff5a5f", "LILIUMARINE DI FABRIZIO CUSUMANO": "#55d12e", "LIQUIGAS SPA": "#7b0051", "M.K.AUTOTRASPORTI CONTO TERZI": "#ffd266", "MAD SNC di MAMELI ADRIANA": "#ff5a5f", "MARMO.IT di Arnaldo Melissa": "#ff3339", "MATRICA SPA": "#ffd266", "MOBILCASA SRL": "#00d1c1", "MOVISTRADE COGEFI S.r.l.": "#00a1b3", "MURA PREFABBRICATI SRL": "#7b0051", "ND": "#ff5a5f", "NIVEA SPA": "#cbc29a", "NOBENTO SPA": "#bbedab", "NUOVA SISMET SRL": "#b4a76c", "OFFICINA MARIO LELLA SRL": "#988b4e", "OFFICINA PELLATI FELICE SNC": "#7b0051", "OFFICINE PORTO TORRES S.R.L.": "#cc0086", "OLEIFICIO SAN MARCO DI SALARIS GB & C": "#ff5a5f", "OLEODINAMICA PIANA SRL": "#55d12e", "ON TECNOLOGY SRL": "#ff5a5f", "ORTU SRL": "#b37e00", "PREMIX": "#007A87", "RIT di Spanu F&C snc": "#cbc29a", "S.M.C. SRLS Sarda Metalmeccanica Costruzioni": "#005c66", "SABBIATURE INDUSTRIALI - SAIND SRL": "#b37e00", "SAFISARDA SRL": "#ffb400", "SANNA MARMI DI SANNA GIUSEPPE": "#cc0086", "SAPIO PRODUZIONE OSSIGENO SRL": "#00a1b3", "SARDA ANTINQUINAMENTO SRL": "#00ffeb", "SARDA CHIMICA SOCIETA' COOPERATIVA SOCIALE A.R.L.": "#ff8083", "SARDA ROTTAMI SRL": "#00b3a5", "SARDA TEGOLE SRL": "#00ffeb", "SARDINIA GLOBAL SERVICE SRL": "#ff3339", "SCA.MO.TER COSTRUZIONI SRL": "#b37e00", "SER.TEC SRL": "#ffd266", "SERVIZI COSTRUZIONI IMPIANTISTICA - SER.CO.IN SRL": "#ff1ab1", "SERVIZI MARITTIMI SRL - SER.MAR SRL": "#ff3339", "SGS AUTOMAZIONE SRL": "#00d1c1", "SIAD SPA": "#55d12e", "SIMULA ALESSIO": "#55d12e", "SWISS PACK MEDITERRANEA SRL": "#00a1b3", "Sergio Cossu": "#ff3339", "T.M.S SRL": "#8ce071", "TECNOCHIMICA SRL": "#b37e00", "TELECOM ITALIA SPA": "#ff8083", "TORREFAZIONE MORGAN": "#8ce071", "TOTAL CAR SRL (in locaz)": "#ff8083", "TRASCARGI SRL": "#00d1c1", "TURRA SRL": "#ff8083", "TURRIS MARKET SRL": "#ff1ab1", "TURRIS SLEEVE": "#cc0086", "Turrismarket S.r.l.": "#005c66", "UNICALCESTRUZZI SPA": "#005c66", "UNICALCESTRUZZI SPA (ENNEBI CALCESTRUZZI)": "#00b3a5", "VERDE VITA": "#00d1c1", "VERSALIS SPA": "#00a1b3", "VIABILA SRL": "#7b0051", "VITTORIO PINNA": "#00ffeb" }, "left_margin": "auto", "max_bubble_size": "25", "series": "zona", "show_legend": true, "size": { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Valore di Produzione", "optionName": "metric_b8nb04mo1fi_pzgx5x5n8c", "sqlExpression": "AVG(totalvalueofproduction::bigint)" }, "slice_id": 45, "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "url_params": {}, "viz_type": "bubble", "x": { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Revenues", "optionName": "metric_tqlt2pz4qp_c6qs291j9pc", "sqlExpression": "AVG(operatingrevenues::bigint)" }, "x_axis_format": "SMART_NUMBER", "x_axis_label": "", "x_axis_showminmax": false, "x_log_scale": false, "x_ticks_layout": "auto", "y": { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Profitto o Perdita", "optionName": "metric_xhbr56uegro_83yr2p0dh4u", "sqlExpression": "AVG(profitorlossfortheyear::bigint)" }, "y_axis_format": "SMART_NUMBER", "y_axis_label": "", "y_axis_showminmax": false, "y_log_scale": false } These parameters are generated dynamically when clicking the save or overwrite button in the explore view. This JSON object is exposed here for reference and for power users who may want to alter specific parameters.
Cache Timeout	Duration (in seconds) of the caching timeout for this chart. Note this defaults to the datasource/table timeout if undefined.