Show Chart

Owners [AdminUser AdminUser, testing test]
Created By AdminUser AdminUser
Changed By AdminUser AdminUser
Created On 2020-03-27 17:10:07
Changed On 2020-06-18 19:12:18
Name Week-Wise : %age Attendance
Datasource Id 278
Datasource Type table
Datasource Name AdminUser AdminUser-Untitled Query-_dOCIvcpT
Visualization Type line
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "0", "expressionType": "SIMPLE", "filterOptionName": "filter_39xt0qa7v6p_7howaxoxsyk", "fromFormData": true, "operator": "!=", "sqlExpression": null, "subject": "logged_in_student" } ], "annotation_layers": [], "bottom_margin": 50, "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "278__table", "granularity_sqla": "ActivityStartDate", "groupby": [], "label_colors": { "Logged In Training.com vs Joined Live Session": "#007A87", "Logged in Training.com vs Joined Live Session": "#ff5a5f", "Students in Batch vs Joined Live Session": "#7b0051" }, "left_margin": "auto", "line_interpolation": "linear", "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Students in Batch vs Joined Live Session", "optionName": "metric_lv2ax7d1qo_zdpmc0u8u", "sqlExpression": "CAST(SUM(attended_student)AS FLOAT)/SUM(total_student)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Logged in Training.com vs Joined Live Session", "optionName": "metric_p77ngp4j5o_kcyaqvzuehj", "sqlExpression": "CAST(SUM(attended_student)AS FLOAT)/SUM(logged_in_student)" } ], "order_desc": true, "resample_method": null, "resample_rule": null, "rich_tooltip": true, "rolling_type": "None", "row_limit": 1000, "send_time_range": false, "show_brush": "auto", "show_legend": true, "show_markers": true, "slice_id": 614, "time_grain_sqla": "P1W", "time_range": "100 years ago : ", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "line", "x_axis_format": "%d/%m/%Y", "x_axis_label": "", "x_axis_showminmax": true, "x_ticks_layout": "auto", "y_axis_bounds": [ null, null ], "y_axis_format": ",.1%", "y_axis_label": "", "y_axis_showminmax": true, "y_log_scale": false }
Description None
Cache Timeout None
Perm [None].[AdminUser AdminUser-Untitled Query-_dOCIvcpT](id:278)
Dashboards [Student Online Session Dashboard]
Email Schedules []