| Column | Verbose Name | Type | Business Data Type | Groupable | Filterable | Is temporal | Extra | |
|---|---|---|---|---|---|---|---|---|
| Item | TEXT | None | None | |||||
| old_cases_A | DOUBLE PRECISION | None | None | |||||
| all_new_B | DOUBLE PRECISION | None | None | |||||
| closed_C | DOUBLE PRECISION | None | None | |||||
| remaining | DOUBLE PRECISION | None | None |
| Metric | Verbose Name | Type | Extra | |
|---|---|---|---|---|
| count | COUNT(*) | count | None | |
| avg__old_cases_A | None | avg | None | |
| sum__all_new_B | None | sum | None | |
| avg__all_new_B | None | avg | None | |
| sum__old_cases_A | None | sum | None | |
| avg__closed_C | None | avg | None | |
| sum__remaining | None | sum | None | |
| avg__remaining | None | avg | None | |
| sum__closed_C | None | sum | None |
| Table Name | 4_9_cases_summary |
|---|---|
| Sql | |
| Enable Filter Select | False |
| Fetch Values Predicate | |
| Database | UNICEF Cambodia |
| Schema | |
| Description | |
| Owners | [Ona ] |
| Main Datetime Column | None |
| Default Endpoint | |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | False |
| Template parameters | |
| Extra | None |
| Normalize Columns | True |
| Always Filter Main Dttm | False |
| Perm | [UNICEF Cambodia].[4_9_cases_summary](id:70) |
| Associated Charts | [Total children, Total children, ចំនួនកុមារសរុប, Distribution by sex, Distribution by sex, Distribution by sex, Distribution by sex, Distribution by sex, Distribution by sex, ចំនួនកុមារទៅតាមប្រទេសសុំ, Total children, Total children, Total children, Number of children by country of adoption, Number of children by country of adoption, ចំនួនកុមារសរុប, ចំនួនកុមារសរុប, Total children] |