Show Chart

Owners [Ali Flaming]
Created By Ali Flaming
Changed By Ali Flaming
Created On 2020-10-27 20:36:11.215750
Changed On 2020-10-27 20:41:17.891526
Name Health care workers vaccinated
Datasource Id 61
Datasource Type table
Datasource Name public.person_dosage_case
Visualization Type big_number_total
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "yes", "expressionType": "SIMPLE", "filterOptionName": "filter_50u9937u78_vqhanplu8rq", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "last_dose_received" } ], "datasource": "61__table", "granularity_sqla": "dose_expiry_date", "header_font_size": 0.3, "metric": { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "is_healthcare_worker", "description": null, "expression": "CASE\r\n WHEN beneficiary_category LIKE '%health%' THEN 'Yes'\r\n ELSE 'No'\r\n END", "filterable": true, "groupby": true, "id": 2312, "is_dttm": false, "optionName": "_col_is_healthcare_worker", "type": "TEXT", "verbose_name": "Healthcare Worker" }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "COUNT_DISTINCT(is_healthcare_worker)", "optionName": "metric_phlnz7c97gk_7ep2po6s8ly", "sqlExpression": null }, "slice_id": 247, "subheader_font_size": 0.125, "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "url_params": { "preselect_filters": "{\"219\": {\"__time_range\": \"No filter\"}, \"222\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "big_number_total", "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 []
Email Schedules []