Show Chart

Owners [Mee Mee Thaw]
Created By Mee Mee Thaw
Changed By Mee Mee Thaw
Created On 2020-08-24 06:41:04.469229
Changed On 2020-08-24 06:41:04.469238
Name What is the perceived impact of contracting COVID?
Datasource Id 21
Datasource Type table
Datasource Name kap.covid_messages_disease_info
Visualization Type pivot_table
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_5ym0cnmequp_x2ies57p8g", "fromFormData": true, "isExtra": false, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "perceived_impact_of_contracting" } ], "columns": [ "perceived_impact_of_contracting" ], "combine_metric": false, "datasource": "21__table", "granularity_sqla": "metadata_today", "groupby": [ "residences", "sex" ], "metrics": [ { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "response_id", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 810, "is_dttm": false, "optionName": "_col_response_id", "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "COUNT_DISTINCT(response_id)", "optionName": "metric_7ijn0cctskj_4u5umyvrqn5", "sqlExpression": null } ], "number_format": "SMART_NUMBER", "pandas_aggfunc": "sum", "pivot_margins": true, "row_limit": 10000, "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "transpose_pivot": false, "url_params": {}, "viz_type": "pivot_table" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_messages_disease_info](id:21)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards []
Email Schedules []