| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_8ry6wmfqweu_vy43ukie3kn",
"fromFormData": true,
"operator": null,
"sqlExpression": "Team in ('IT (CC)','IT (Field)')",
"subject": null
}
],
"align_pn": false,
"all_columns": [],
"color_pn": true,
"datasource": "407__table",
"granularity_sqla": "Date",
"groupby": [
"PA_Name"
],
"include_search": false,
"include_time": false,
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5913,
"is_dttm": false,
"optionName": "_col_Leads",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Leads",
"optionName": "metric_hts8pyaaw8j_elruvahlt7",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Contacted",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5914,
"is_dttm": false,
"optionName": "_col_Contacted",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Contacted",
"optionName": "metric_zhm5pey4ari_racgzrs68wl",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Eligible",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5915,
"is_dttm": false,
"optionName": "_col_Eligible",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Eligible",
"optionName": "metric_pf8gxm2qqm_efnqm3espmt",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Interested",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5916,
"is_dttm": false,
"optionName": "_col_Interested",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Interested",
"optionName": "metric_38xg2md00df_t7ytu80ew8q",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "App_Pending",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5917,
"is_dttm": false,
"optionName": "_col_App_Pending",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "App Pending",
"optionName": "metric_dav52pupjid_4lzvdp20apt",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Screening_1_Pending",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5918,
"is_dttm": false,
"optionName": "_col_Screening_1_Pending",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Screen 1 Pending",
"optionName": "metric_jh9n1yemkw_6oq2ksz9xxt",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Screening_2_Pending",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5919,
"is_dttm": false,
"optionName": "_col_Screening_2_Pending",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Screen 2 Pending",
"optionName": "metric_lowq4js3vdo_gnnlhib7nhr",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Payment_Pending",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5920,
"is_dttm": false,
"optionName": "_col_Payment_Pending",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Payment Pending",
"optionName": "metric_nq6p8p82sl_5rfq7iifqc7",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Registered",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5921,
"is_dttm": false,
"optionName": "_col_Registered",
"python_date_format": null,
"type": "INT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Registered",
"optionName": "metric_rmcm4g0q3oc_n2adb8rbehc",
"sqlExpression": null
},
{
"aggregate": "AVG",
"column": {
"column_name": "Callhandling",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 5923,
"is_dttm": false,
"optionName": "_col_Callhandling",
"python_date_format": null,
"type": "OBJECT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Avg. Call Handling Time",
"optionName": "metric_3dyoam9v30m_e01p4tz7v6h",
"sqlExpression": null
}
],
"order_by_cols": [],
"order_desc": true,
"page_length": 0,
"percent_metrics": [],
"row_limit": 1000,
"slice_id": 753,
"table_filter": false,
"table_timestamp_format": "%Y-%m-%d %H:%M:%S",
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"timeseries_limit_metric": null,
"viz_type": "table"
}
|
