| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": "5w71c",
"expressionType": "SIMPLE",
"filterOptionName": "filter_ox2zlynmrqb_x6d1bicxgpb",
"isExtra": false,
"isNew": false,
"operator": "==",
"sqlExpression": null,
"subject": "projectminihash"
},
{
"clause": "WHERE",
"comparator": [
"061",
"070",
"087",
"081",
"080"
],
"expressionType": "SIMPLE",
"filterOptionName": "filter_awufg8tgzfr_tnca1xuhq8",
"isExtra": false,
"isNew": false,
"operator": "in",
"sqlExpression": null,
"subject": "rn"
},
{
"clause": "WHERE",
"comparator": [
"Via\u00e7\u00e3o Cidade Morena",
"Via\u00e7\u00e3o S\u00e3o Francisco"
],
"expressionType": "SIMPLE",
"filterOptionName": "filter_f5usvtd5gs_s1k1zw61gbe",
"isExtra": false,
"isNew": false,
"operator": "in",
"sqlExpression": null,
"subject": "company"
}
],
"bar_stacked": false,
"bottom_margin": "auto",
"color_scheme": "supersetColors",
"columns": [],
"contribution": false,
"datasource": "261__table",
"granularity_sqla": "chargeday",
"groupby": [
"rn",
"dayoperacao",
"company"
],
"label_colors": {},
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "planejado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2065,
"is_dttm": false,
"optionName": "_col_planejado",
"python_date_format": null,
"type": "INT",
"verbose_name": "1-Planejado"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "1-Planejado",
"optionName": "metric_ahgnp200x7o_8h4rqhhmrs8",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "monitorado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2064,
"is_dttm": false,
"optionName": "_col_monitorado",
"python_date_format": null,
"type": "INT",
"verbose_name": "2-Monitorado"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "2-Monitorado",
"optionName": "metric_kaxnt436gym_hy9p8hh9ace",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "porcentagemmonitorado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2066,
"is_dttm": false,
"optionName": "_col_porcentagemmonitorado",
"python_date_format": null,
"type": "INT",
"verbose_name": "3-Efici\u00eancia (%)"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "3-Efici\u00eancia (%)",
"optionName": "metric_2vkczbwjcuc_8l0kyrddl8p",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "pontual",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2060,
"is_dttm": false,
"optionName": "_col_pontual",
"python_date_format": null,
"type": null,
"verbose_name": "4-Pontual"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "4-Pontual",
"optionName": "metric_45q81vn6j73_o5r7hfjqoxp",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "porcentagempontual",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2069,
"is_dttm": false,
"optionName": "_col_porcentagempontual",
"python_date_format": null,
"type": null,
"verbose_name": "5-Pontual (%)"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "5-Pontual (%)",
"optionName": "metric_p8z9aa1tos_1z293ap8pze",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "adiantado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2062,
"is_dttm": false,
"optionName": "_col_adiantado",
"python_date_format": null,
"type": null,
"verbose_name": "6-Adiantado"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "6-Adiantado",
"optionName": "metric_qepga3catn_smgbqpdvlb",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "porcentagemadiantado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2068,
"is_dttm": false,
"optionName": "_col_porcentagemadiantado",
"python_date_format": null,
"type": null,
"verbose_name": "7-Adiantado (%)"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "7-Adiantado (%)",
"optionName": "metric_rt5rrl2po4_zkl197vjjz",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "atrasado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2061,
"is_dttm": false,
"optionName": "_col_atrasado",
"python_date_format": null,
"type": null,
"verbose_name": "8-Atrasado"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "8-Atrasado",
"optionName": "metric_9f54fi4nazu_v1oqmri5ntm",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "porcentagematrasado",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2067,
"is_dttm": false,
"optionName": "_col_porcentagematrasado",
"python_date_format": null,
"type": null,
"verbose_name": "9-Atrasado (%)"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "9-Atrasado (%)",
"optionName": "metric_ley047250p_7kkwizk43os",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "extra",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2063,
"is_dttm": false,
"optionName": "_col_extra",
"python_date_format": null,
"type": null,
"verbose_name": "10-Extra"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "10-Extra",
"optionName": "metric_u5l6xkoy18_rur1s2camo",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "porcentagemextra",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2070,
"is_dttm": false,
"optionName": "_col_porcentagemextra",
"python_date_format": null,
"type": null,
"verbose_name": "10-Extra (%)"
},
"expressionType": "SIMPLE",
"hasCustomLabel": true,
"isNew": false,
"label": "11-Extra (%)",
"optionName": "metric_2lbltafm9ja_7c4a8u7lx2d",
"sqlExpression": null
}
],
"order_bars": false,
"queryFields": {
"columns": "groupby",
"groupby": "groupby",
"metrics": "metrics"
},
"reduce_x_ticks": false,
"row_limit": null,
"show_bar_value": true,
"show_controls": false,
"show_legend": true,
"slice_id": 1473,
"time_range": "2020-12-15T00:00:00 : 2020-12-22T00:00:00",
"time_range_endpoints": [
"inclusive",
"exclusive"
],
"url_params": {},
"viz_type": "dist_bar",
"x_axis_label": "",
"x_ticks_layout": "auto",
"y_axis_format": "SMART_NUMBER",
"y_axis_label": ""
}
|
