Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 17:13:18.465353
Changed On 2020-07-07 17:11:44.331810
Name Where are you getting information about the disease from?
Datasource Id 21
Datasource Type table
Datasource Name kap.covid_messages_disease_info
Visualization Type pivot_table
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "disease_information_sources", "expressionType": "SIMPLE", "filterOptionName": "filter_9q50hp04ybm_ad0fvngp6fd", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "arrayname" } ], "columns": [ "option_label" ], "combine_metric": false, "datasource": "21__table", "granularity_sqla": "metadata_today", "groupby": [ "residences", "sex" ], "metrics": [ { "aggregate": "COUNT", "column": { "column_name": "option_label", "database_expression": null, "description": null, "expression": null, "filterable": true, "groupby": true, "id": 68543, "is_dttm": null, "optionName": "_col_option_label", "python_date_format": null, "type": "VARCHAR", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "No. of Respondents", "optionName": "metric_1vbvmt15p64_4twu8sk1w9", "sqlExpression": null } ], "number_format": "1000", "pandas_aggfunc": "sum", "pivot_margins": false, "row_limit": 10000, "slice_id": 224, "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "unknown", "inclusive" ], "transpose_pivot": false, "url_params": { "preselect_filters": "{\"223\": {\"__time_range\": \"No filter\"}, \"241\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "pivot_table" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_messages_disease_info](id:21)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards [UNICEF Cambodia Covid-19 Awareness Survey (English)]
Email Schedules []