| Parameters |
{
"adhoc_filters": [],
"align_pn": false,
"all_columns": [],
"color_pn": true,
"datasource": "431__table",
"granularity_sqla": null,
"groupby": [
"PA_Name"
],
"include_search": false,
"include_time": false,
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6603,
"is_dttm": false,
"optionName": "_col_plnnd_Leads",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned Leads",
"optionName": "metric_yirn6sjxbl_01fffsckfz1n",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual Leads",
"optionName": "metric_nwx93zvgge_n5rlcnylfu8",
"sqlExpression": "isnull(SUM(actl_Leads),0)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_calls",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6605,
"is_dttm": false,
"optionName": "_col_plnnd_calls",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned Calls",
"optionName": "metric_a1ztlg03hob_dc0r7ifb77q",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual Calls",
"optionName": "metric_l4b72w33xgs_e1sngwyjtgm",
"sqlExpression": "isnull(SUM(actl_calls),0)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_app_compltd",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6607,
"is_dttm": false,
"optionName": "_col_plnnd_app_compltd",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned App Completed",
"optionName": "metric_t2l8vkof0nj_0wokwnkys4c",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual App Completed",
"optionName": "metric_mhh5aw6n6w_6wzhoja5e45",
"sqlExpression": "isnull(SUM(actl_app_cmpltd),0)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_scrning_cmpltd",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6609,
"is_dttm": false,
"optionName": "_col_plnnd_scrning_cmpltd",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned Screening Completed",
"optionName": "metric_zp0y82zgfvc_zory15yo43",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual Screening Completed",
"optionName": "metric_8fus77xmgom_f97ojbabzch",
"sqlExpression": "isnull(SUM(actl_scrning_cmpltd),0)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_Reg_career",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6611,
"is_dttm": false,
"optionName": "_col_plnnd_Reg_career",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned Reg Career",
"optionName": "metric_ra5gyc71a6_8cf8uqwliyr",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual Reg Career",
"optionName": "metric_dxrtz5n2t8_4ghzv33dtce",
"sqlExpression": "isnull(SUM(actl_Reg_career),0)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "plnnd_Reg_mdlr",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6613,
"is_dttm": false,
"optionName": "_col_plnnd_Reg_mdlr",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Planned Reg Modular",
"optionName": "metric_bfj5l0uj6dv_y7o4wyzv07",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Actual Reg Modular",
"optionName": "metric_90tze6rx7x9_ik705neov8f",
"sqlExpression": "isnull(SUM(actl_Reg_mdlr),0)"
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "OI Contribution",
"optionName": "metric_9zmeknx501l_owoo7ai62im",
"sqlExpression": "isnull(SUM(OI_Contribution),0)"
}
],
"order_by_cols": [],
"order_desc": false,
"page_length": 0,
"percent_metrics": [],
"row_limit": 10000,
"slice_id": 844,
"table_filter": false,
"table_timestamp_format": "%Y-%m-%d %H:%M:%S",
"time_grain_sqla": "P1D",
"time_range": "No filter",
"timeseries_limit_metric": {
"aggregate": "MAX",
"column": {
"column_name": "PA_Name",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 6601,
"is_dttm": false,
"optionName": "_col_PA_Name",
"python_date_format": null,
"type": "STRING",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": false,
"label": "MAX(PA_Name)",
"optionName": "metric_6pigdkgy0rf_gairq0vqcve",
"sqlExpression": null
},
"viz_type": "table"
}
|
