Show Chart

Owners [Prem Kasha, Clara Mloza-Banda, Sankalp Samal, Ali Flaming]
Created By Ali Flaming
Changed By Clara Mloza-Banda
Created On 2020-11-11 21:15:07.039817
Changed On 2020-11-25 11:24:11.540778
Name % Lost to follow-up
Datasource Id 61
Datasource Type table
Datasource Name public.person_dosage_case
Visualization Type big_number
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "2", "expressionType": "SIMPLE", "filterOptionName": "filter_93m3sty7poo_nu8vzc0qioh", "isExtra": false, "isNew": false, "operator": "==", "sqlExpression": null, "subject": "dose_number" }, { "clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_d5gljsyiu9h_j8wbuzhfaxj", "isExtra": false, "isNew": false, "operator": null, "sqlExpression": "CAST(dose_expiry_date AS TIMESTAMP) < '2020-11-01 00:00:00'", "subject": null } ], "color_picker": { "a": 1, "b": 49, "g": 44, "r": 193 }, "compare_lag": 0, "compare_suffix": "over last day", "datasource": "61__table", "granularity_sqla": "dose_expiry_date", "header_font_size": 0.5, "metric": "percentage_lost_to_followup_trend", "queryFields": { "metric": "metrics" }, "rolling_type": "cumsum", "show_trend_line": true, "slice_id": 278, "start_y_axis_at_zero": true, "subheader_font_size": 0.2, "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "url_params": { "preselect_filters": "{\"263\": {\"__time_range\": \"No filter\"}, \"267\": {\"state_name\": [\"Demo Uttar Pradesh\"]}, \"270\": {\"__time_range\": \"No filter\"}, \"271\": {\"__time_range\": \"No filter\"}, \"273\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "big_number", "y_axis_format": ",.1%" }
Description None
Cache Timeout None
Perm [COVID Vaccine Demo].[person_dosage_case](id:61)
Schema Perm [COVID Vaccine Demo].[public]
Dashboards [COVID-19 Vaccination Dashboard]
Email Schedules []