Show Chart

Owners [MCO ICT]
Created By MCO ICT
Changed By MCO ICT
Created On 2020-08-24 06:42:48.211130
Changed On 2020-08-24 06:42:48.211142
Name chitthal_ 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_u7148xofh5k_9scejmca84a", "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": [ "residence", "sex" ], "metrics": [ { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "unique_id", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 798, "is_dttm": false, "optionName": "_col_unique_id", "type": "UUID", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": false, "label": "COUNT_DISTINCT(unique_id)", "optionName": "metric_b9vspi01267_0ivuajk9xvv", "sqlExpression": null } ], "number_format": "SMART_NUMBER", "pandas_aggfunc": "sum", "pivot_margins": true, "row_limit": 10000, "time_grain_sqla": "P1D", "time_range": "Last week", "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 []