Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table khmer.indicator2_4dhis_khmer
Created By Ona
Changed By Ona
Uuid 38ac5165-092f-29e8-dcc8-4d2744573919
Created On 2021-11-22 12:41:22.939672
Changed On 2021-11-22 12:41:22.939682
Name ទៅតាមស្ថានភាព​អាពាហ៍ពិពាហ៍
Datasource Id 145
Datasource Type table
Datasource Name khmer.indicator2_4dhis_khmer
Visualization Type pivot_table_v2
Parameters {"datasource": "3505__table", "viz_type": "pivot_table_v2", "slice_id": 18503, "url_params": {}, "time_grain_sqla": "P1D", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(sought_help_to_stop_violence)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1794\u17b6\u1793\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1787\u17c6\u1793\u17bd\u1799", "optionName": "metric_9mdyhypg5m_ale6ler0kfj"}, {"expressionType": "SQL", "sqlExpression": "SUM(never_sought_help_to_stop_violence_but_told_someone)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1798\u17b7\u1793\u179a\u1780\u1787\u17c6\u1793\u1799\u1794\u17c9\u1793\u17d2\u178f\u17c2\u1794\u17d2\u179a\u17b6\u1794\u17cb", "optionName": "metric_ytnzbafoec9_jaejo77pvbe"}, {"expressionType": "SQL", "sqlExpression": "SUM(never_sought_help_to_stop_violence_and_never_told_anyone)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1798\u17b7\u1793\u179a\u1780\u1787\u17c6\u1793\u17bd\u1799", "optionName": "metric_fnwzpfuvuim_wdmdf7cxjd"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "category", "operator": "==", "comparator": "Marital status", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_e35gawz2qim_zaxs9evkab"}], "groupbyRows": ["khmer_updated"], "groupbyColumns": [], "series_limit": 10000, "aggregateFunction": "Sum", "valueFormat": ",.3f", "combineMetric": false, "remote_id": 18503, "datasource_name": "indicator2_4dhis_khmer", "schema": "khmer", "database_name": "UNICEF Cambodia", "import_time": 1637584674, "rowOrder": "value_z_to_a", "form_data_bak": {"datasource": "3505__table", "viz_type": "pivot_table", "slice_id": 18503, "url_params": {}, "granularity_sqla": null, "time_grain_sqla": "P1D", "time_range": "Last week", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(sought_help_to_stop_violence)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1794\u17b6\u1793\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1787\u17c6\u1793\u17bd\u1799", "optionName": "metric_9mdyhypg5m_ale6ler0kfj"}, {"expressionType": "SQL", "sqlExpression": "SUM(never_sought_help_to_stop_violence_but_told_someone)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1798\u17b7\u1793\u179a\u1780\u1787\u17c6\u1793\u1799\u1794\u17c9\u1793\u17d2\u178f\u17c2\u1794\u17d2\u179a\u17b6\u1794\u17cb", "optionName": "metric_ytnzbafoec9_jaejo77pvbe"}, {"expressionType": "SQL", "sqlExpression": "SUM(never_sought_help_to_stop_violence_and_never_told_anyone)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u1798\u17b7\u1793\u179a\u1780\u1787\u17c6\u1793\u17bd\u1799", "optionName": "metric_fnwzpfuvuim_wdmdf7cxjd"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "category", "operator": "==", "comparator": "Marital status", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_e35gawz2qim_zaxs9evkab"}], "groupby": ["khmer_updated"], "columns": [], "row_limit": 10000, "pandas_aggfunc": "sum", "pivot_margins": false, "number_format": ",.3f", "combine_metric": false, "remote_id": 18503, "datasource_name": "indicator2_4dhis_khmer", "schema": "khmer", "database_name": "UNICEF Cambodia", "import_time": 1637584674}}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator2_4dhis_khmer](id:145)
Schema Perm [UNICEF Cambodia].[khmer]
Last Saved At 2021-11-22 12:41:22.939682
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<32>]
Report Schedules []