Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
date | DATETIME | |||||
total_total | None | BIGINT | ||||
boys_total | None | BIGINT | ||||
girls_total | None | BIGINT | ||||
total_injured | None | BIGINT | ||||
boys_injured | None | BIGINT | ||||
girls_injured | None | BIGINT | ||||
total_amputeted | None | BIGINT | ||||
boys_amputeted | None | BIGINT | ||||
girls_amputeted | None | BIGINT | ||||
total_killed | None | BIGINT | ||||
boys_killed | None | BIGINT | ||||
girls_killed | None | BIGINT | ||||
year | DATETIME |
Metric | Verbose Name | Type | |
---|---|---|---|
sum__year | None | sum | |
avg__year | None | avg | |
sum__total_total | None | sum | |
avg__total_total | None | avg | |
sum__boys_total | None | sum | |
avg__boys_total | None | avg | |
sum__girls_total | None | sum | |
avg__girls_total | None | avg | |
sum__total_injured | None | sum | |
avg__total_injured | None | avg | |
sum__boys_injured | None | sum | |
avg__boys_injured | None | avg | |
sum__girls_injured | None | sum | |
avg__girls_injured | None | avg | |
sum__total_amputeted | None | sum | |
avg__total_amputeted | None | avg | |
sum__boys_amputeted | None | sum | |
avg__boys_amputeted | None | avg | |
sum__girls_amputeted | None | sum | |
avg__girls_amputeted | None | avg | |
sum__total_killed | None | sum | |
avg__total_killed | None | avg | |
sum__boys_killed | None | sum | |
avg__boys_killed | None | avg | |
sum__girls_killed | None | sum | |
avg__girls_killed | None | avg | |
count | COUNT(*) | count |
Table Name | indicator5_17_trend |
---|---|
Sql | None |
Enable Filter Select | False |
Fetch Values Predicate | None |
Database | UNICEF Cambodia |
Schema | None |
Description | None |
Owners | [] |
Main Datetime Column | None |
Default Endpoint | None |
Offset | 0 |
Cache Timeout | None |
SQL Lab View | False |
Template parameters | None |
Perm | [UNICEF Cambodia].[indicator5_17_trend](id:47) |
Associated Charts | [Number of Total casualties over time, Injured over time, Amputated over time, Killed over time, Number of Total casualties over time, Injured over time, Amputated over time, Killed over time] |