| Parameters |
{
"adhoc_filters": [],
"align_pn": false,
"all_columns": [],
"color_pn": true,
"datasource": "365__table",
"granularity_sqla": "Date",
"groupby": [
"PA_Name",
"Vertical",
"Product_Type"
],
"include_search": false,
"include_time": false,
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4780,
"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_29qyhuneik2_lnuwj96jat",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Contacted",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4781,
"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_38boyhbc37b_746n7yh535p",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Eligible",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4782,
"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_9gi4ejnspar_0asl2gue6lxr",
"sqlExpression": null
},
{
"aggregate": "SUM",
"column": {
"column_name": "Interested",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4783,
"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_v05wg8t4m0p_ai2hcm86m4l",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "App Pending",
"optionName": "metric_49nkpi1lvv2_09mgxmz87h",
"sqlExpression": "SUM(App_Pending)"
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Screening 1 Pending",
"optionName": "metric_2542j4ixsdm_am75q415rh",
"sqlExpression": "SUM(Screening_1_Pending)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "Screening_2_Pending",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4786,
"is_dttm": false,
"optionName": "_col_Screening_2_Pending",
"python_date_format": null,
"type": "INT",
"verbose_name": "Screening 2 Pending"
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Screening 2 Pending",
"optionName": "metric_8mly4dkv09n_sze1aocohz",
"sqlExpression": null
},
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Payment Pending",
"optionName": "metric_dxn9zf1uo3j_ztdaz1pu44i",
"sqlExpression": "SUM(Payment_Pending)"
},
{
"aggregate": "SUM",
"column": {
"column_name": "Registered",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 4788,
"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_m5nkjywzuc_7r05akxg4uc",
"sqlExpression": null
}
],
"order_by_cols": [],
"order_desc": true,
"page_length": 0,
"percent_metrics": [],
"row_limit": 1000,
"slice_id": 670,
"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,
"url_params": {},
"viz_type": "table"
}
|
