| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_vf5izmm96u_o1d7fpvy9dt",
"fromFormData": true,
"operator": null,
"sqlExpression": "AppActivationDate >='2019-01-01'",
"subject": null
},
{
"clause": "WHERE",
"comparator": "PPDEP",
"expressionType": "SIMPLE",
"filterOptionName": "filter_sglstkd47cp_u3gx56i8qw",
"fromFormData": true,
"operator": "==",
"sqlExpression": null,
"subject": "CourseCode"
}
],
"annotation_layers": [],
"bar_stacked": false,
"bottom_margin": "auto",
"color_scheme": "bnbColors",
"comparison_type": "values",
"contribution": false,
"datasource": "244__table",
"granularity_sqla": "AppActivationDate",
"groupby": [
"activationType"
],
"label_colors": {
"Ahmedabad": "#55d12e",
"App Installs": "#8ce071",
"Automated": "#00a1b3",
"Average Rating": "#7b0051",
"BP": "#7b0051",
"Bangalore": "#005c66",
"Career Programs": "#ff5a5f",
"CareerSeries": "#b4a76c",
"Chennai": "#cbc29a",
"Delhi & NCR": "#00ffeb",
"Delhi Networks": "#ff3339",
"Faculty": "#cc0086",
"Hyderabad": "#b37e00",
"Kolkata": "#ffd266",
"Mumbai": "#bbedab",
"NCS": "#988b4e",
"North Networks II": "#00b3a5",
"OWN": "#ff5a5f",
"Other Courses": "#ffb400",
"Pune": "#ff1ab1",
"Session Marked By App": "#007A87",
"Session Rating(in%)": "#007A87",
"TPAAS": "#ff8083",
"Total Session to be Marked": "#00d1c1"
},
"left_margin": "auto",
"line_interpolation": "linear",
"metrics": [
{
"aggregate": "COUNT_DISTINCT",
"column": {
"column_name": "CustomerID",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 2186,
"is_dttm": false,
"optionName": "_col_CustomerID",
"python_date_format": null,
"type": "FLOAT(53)",
"verbose_name": null
},
"expressionType": "SIMPLE",
"fromFormData": true,
"hasCustomLabel": true,
"label": "App Installs",
"optionName": "metric_xkldex4z51j_0il3hjso052a",
"sqlExpression": null
}
],
"order_desc": true,
"reduce_x_ticks": false,
"resample_method": null,
"resample_rule": null,
"rich_tooltip": true,
"rolling_type": "None",
"row_limit": 10000,
"show_bar_value": true,
"show_brush": "auto",
"show_controls": false,
"show_legend": true,
"slice_id": 565,
"time_grain_sqla": "P1M",
"time_range": "No filter",
"timeseries_limit_metric": null,
"url_params": {},
"viz_type": "bar",
"x_axis_format": "smart_date",
"x_axis_label": "",
"x_axis_showminmax": false,
"x_ticks_layout": "45u00b0",
"y_axis_bounds": [
null,
null
],
"y_axis_format": "SMART_NUMBER",
"y_axis_label": "",
"y_axis_showminmax": false,
"y_log_scale": false
}
|
