Column | Verbose Name | Type | Business Data Type | Groupable | Filterable | Is temporal | Extra | |
---|---|---|---|---|---|---|---|---|
adopted | Adopted | STRING | None | None | ||||
costed | Costed | STRING | None | None | ||||
funded | Funded | STRING | None | None | ||||
development | In Development | STRING | None | None | ||||
objective | Key objective | STRING | None | None | ||||
link | Link to the document | STRING | None | None | ||||
name_plans | Name of the plan or strategy | STRING | None | None | ||||
plans | Plans or Strategies | STRING | None | None | ||||
ministry | Responsible Ministry or institution | STRING | None | None | ||||
implementation | Under implementation | STRING | None | None |
Table Name | Brian Cheye-Query indicator1_8_data-SrbphRwCt |
---|---|
Sql | SELECT "Plans or Strategies" as plans, "Name of the plan or strategy" as name_plans, "Key objective" as objective, "In Development" as development, "Adopted" as adopted, "Costed" as costed, "Funded" as funded, "Under implementation" as implementation, "Responsible Ministry or institution" as ministry, concat('<a href=',"Link to the document",'>Link</a>') as "link" FROM indicator1_8_data GROUP BY "Plans or Strategies", "Name of the plan or strategy", "Key objective", "In Development", "Adopted", "Costed", "Funded", "Under implementation", "Responsible Ministry or institution", "Link to the document" ORDER BY COUNT(*) DESC LIMIT 10000 |
Enable Filter Select | False |
Fetch Values Predicate | None |
Database | UNICEF Cambodia |
Schema | null |
Description | None |
Owners | [Ona ] |
Main Datetime Column | None |
Default Endpoint | None |
Offset | 0 |
Cache Timeout | None |
SQL Lab View | False |
Template parameters | {} |
Extra | None |
Normalize Columns | True |
Perm | [UNICEF Cambodia].[Brian Cheye-Query indicator1_8_data-SrbphRwCt](id:61) |
Associated Charts | [Progress, Progress] |