SUPERSET

curl --location --request POST '/superset/explore_json' \
--header 'Content-Type: application/json' \
--data-raw '{"datasource": "74__table", "viz_type": "filter_box", "slice_id": 451, "url_params": {}, "time_range_endpoints": ["inclusive", "exclusive"], "granularity_sqla": "datehour", "time_grain_sqla": "P1D", "time_range": "Last month", "filter_configs": [{"asc": true, "clearable": true, "column": "currency", "defaultValue": "USD_VALUE", "key": "dVDGl5P9N", "label": "Currency", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "partnername", "key": "Q47tGi9ag", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "currency", "defaultValue": "USD_VALUE", "key": "kCutdvlws", "label": "Currency", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "gametype", "key": "rQZwyQlap", "label": "Game Type", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "clientname", "key": "ZXp3arteQ", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "clientplayerid", "key": "2LGl3QKOk", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "partnername", "key": "XJ5d_ghK6", "label": "Partner", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "clientname", "key": "Quohw_sZc", "label": "Client", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "partnername", "key": "PJw8o07GN", "label": "Partner", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "clientname", "key": "sbrOSGcLV", "label": "Client", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "referencecode", "key": "zVPBHwaOs", "multiple": true, "searchAllOptions": false}, {"asc": true, "clearable": true, "column": "gametypename", "key": "DDNhn3KaE", "label": "Game Sub Type", "multiple": true, "searchAllOptions": false}], "date_filter": true, "adhoc_filters": [{"clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_yyfe8br946j_deifv6ml5c", "isExtra": false, "isNew": false, "operator": null, "sqlExpression": "yearid = date_format(current_date, '\''%Y'\'')", "subject": null}], "label_colors": {}, "extra_filters": [{"col": "__time_range", "op": "==", "val": "Last day"}, {"col": "currency", "op": "IN", "val": ["USD_VALUE"]}], "dashboardId": 42, "instant_filtering": true, "show_sqla_time_column": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "win", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 897, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Win", "optionName": "metric_mefh7k26e8_mw99mu4jq2e", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "bets", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 856, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Bet", "optionName": "metric_3eb38crrg0v_qaug6ee0zes", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "# Players", "optionName": "metric_ptcewwrfne_r6jqov6jgee", "sqlExpression": "COUNT(DISTINCT internalplayerid)"}, {"aggregate": "SUM", "column": {"column_name": "bets", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1630, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Bets", "optionName": "metric_gl254y64t14_vbp6pqjb1a", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "EV Year to Date", "optionName": "metric_3y0x1n945um_f97ikzzmo6d", "sqlExpression": "cast(SUM(if(yearid like date_format(current_date, '\''%Y'\''), theowin,0)) as decimal(18,2))"}, {"aggregate": "SUM", "column": {"column_name": "bets", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 896, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Bet", "optionName": "metric_y2989lnoot_o75mjfvohl", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Hold %", "optionName": "metric_09gshwz1szcd_geykmsx521e", "sqlExpression": "ROUND((SUM(win)/SUM(bets))*100,1)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Hold Perc", "optionName": "metric_dfnthtlkit4_ykzs0nc3q8r", "sqlExpression": "IF( sum(bets) > 0, SUM(win) / SUM(bets) , 0 )"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Std Dev", "optionName": "metric_xz7o9yd36rq_386ewlk75eh", "sqlExpression": "IF( sqrt( sum( POW(oneStd, 2.0) ) ) > 0, ( SUM(win) - SUM(ev) ) / sqrt( sum( POW(oneStd, 2.0) ) ), 0)"}, {"aggregate": "SUM", "column": {"column_name": "win", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1264, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Win", "optionName": "metric_yaf176ppdh_16kt5y6xq95", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "MTD Hold%", "optionName": "metric_0g2jpgwmvgdr_05n9r3qrnb6c", "sqlExpression": "ROUND(TRY(\r\nSUM(if(monthid like date_format(current_date, '\''%M'\''), win,0))/\r\nSUM(if(monthid like date_format(current_date, '\''%M'\''), bets,1)))*100,1)"}, {"aggregate": "SUM", "column": {"column_name": "ev", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1632, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "EV", "optionName": "metric_pvwei3m68lr_2ti9xmua2tq", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "win", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 857, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Win", "optionName": "metric_a7jcbwbju3m_fhdcnli1r3h", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "YTD Hold%", "optionName": "metric_wg8vwygik1_o9g3o116dw", "sqlExpression": "ROUND(TRY(\nSUM(if(yearid like date_format(current_date, '\''%Y'\''), win,0))/\nSUM(if(yearid like date_format(current_date, '\''%Y'\''), bets,0)))*100,1)"}, {"aggregate": "COUNT_DISTINCT", "column": {"column_name": "internalplayerid", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 890, "is_dttm": false, "python_date_format": null, "type": "VARCHAR", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "# Players", "optionName": "metric_0wvwp90zck6_5gym2ocwll4", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Bet Year to Date", "optionName": "metric_9ukjmsna988_5amik4qnbnp", "sqlExpression": "cast(SUM(if(yearid like date_format(current_date, '\''%Y'\''), bets,0)) as decimal(18,2))"}, {"aggregate": "SUM", "column": {"column_name": "theowin", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 900, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "EV", "optionName": "metric_lreazyye6x_095tuyjf37lw", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Hold%", "optionName": "metric_lt2062fyyfk_sz9mfvd5ija", "sqlExpression": "ROUND((sum(win)/SUM(bets))*100,1)"}, {"aggregate": "SUM", "column": {"column_name": "win", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1631, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Win", "optionName": "metric_703e16scasl_hqe5wjsgx7", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Bet Month to Date", "optionName": "metric_ikwbvwg7yad_q0ymm237lv", "sqlExpression": "cast(SUM(if(monthid like date_format(current_date, '\''%M'\''), bets,0)) as DECIMAL(18,2))"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "EV Month to Date", "optionName": "metric_8ptkyxsyp2_tgomvfzrqt", "sqlExpression": "cast(SUM(if(monthid like date_format(current_date, '\''%M'\''), theowin,0)) as decimal(18,2))"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "EV Hold Perc", "optionName": "metric_lnqvd3xihle_sbvfhi78kr", "sqlExpression": "IF( SUM(bets) > 0, SUM(ev) / SUM(bets), 0 )"}, {"aggregate": "SUM", "column": {"column_name": "theowin", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 900, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "EV", "optionName": "metric_fvk631czyqk_5y3xptwnbys", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "ev", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1265, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "EV", "optionName": "metric_dmr52d2k3ui_3s7lnnzrqik", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Win Year to Date", "optionName": "metric_ewuqr1wy5c_rpz9ebpzg6q", "sqlExpression": "cast(SUM(if(yearid like date_format(current_date, '\''%Y'\''), win,0)) as decimal(18,2))"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Win", "optionName": "metric_7mjxmz8t8fm_svc7u2nz2ga", "sqlExpression": "CAST(SUM(win) as int)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Bet", "optionName": "metric_69rmowhmut8_dqt8tfc9we", "sqlExpression": "CAST(SUM(bets) as int)"}, {"aggregate": "SUM", "column": {"column_name": "theowin", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 860, "is_dttm": false, "python_date_format": null, "type": "DECIMAL", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "EV", "optionName": "metric_qldk9iyge0j_n7l2bussqn9", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": true, "isNew": false, "label": "Win Month to Date", "optionName": "metric_laegzs53lwc_v38s77po6pq", "sqlExpression": "cast(SUM(if(monthid like date_format(current_date, '\''%M'\''), win,0)) as decimal(18,2))"}, {"aggregate": "SUM", "column": {"column_name": "bets", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1263, "is_dttm": false, "python_date_format": null, "type": "DOUBLE", "verbose_name": null}, "expressionType": "SIMPLE", "hasCustomLabel": true, "isNew": false, "label": "Bet", "optionName": "metric_somhofxcs7e_10yqwlz2plum", "sqlExpression": null}], "groupby": ["gametypename", "clientname", "partnername", "bettypegroupname"], "columns": [], "row_limit": 10000, "order_desc": true, "color_scheme": "supersetColors", "y_axis_format": "SMART_NUMBER", "y_axis_bounds": [null], "bottom_margin": "auto", "x_ticks_layout": "auto", "pandas_aggfunc": "sum", "pivot_margins": false, "number_format": "SMART_NUMBER", "date_format": "smart_date", "metric": {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": false, "isNew": false, "label": "IF( sqrt( sum( POW(oneStd, 2.0) ) ) > 0,...", "optionName": "metric_ctxziw86fjj_zt6bwfil2y", "sqlExpression": "IF( sqrt( sum( POW(oneStd, 2.0) ) ) > 0, ( SUM(win) - SUM(ev) ) / sqrt( sum( POW(oneStd, 2.0) ) ), 0)"}, "show_trend_line": true, "start_y_axis_at_zero": true, "color_picker": {"a": 1, "b": 135, "g": 122, "r": 0}, "header_font_size": 0.4, "subheader_font_size": 0.15, "rolling_type": "cumsum", "timeseries_limit_metric": {"aggregate": null, "column": null, "expressionType": "SQL", "hasCustomLabel": false, "isNew": false, "label": "ABS(SUM(win))", "optionName": "metric_rg4qytxqnc_x509ov5qjq", "sqlExpression": "ABS(SUM(win))"}}'