Column | Verbose Name | Type | Business Data Type | Groupable | Filterable | Is temporal | Extra | |
---|---|---|---|---|---|---|---|---|
adopted | Adopted | STRING | None | None | ||||
costed | Costed | STRING | None | None | ||||
development | In Development | STRING | None | None | ||||
funded | Funded | STRING | None | None | ||||
implementation | Under implementation | STRING | None | None | ||||
link | Link to the document | STRING | None | None | ||||
ministry | Responsible Ministry or institution | STRING | None | None | ||||
name_plans | Name of the plan or strategy | STRING | None | None | ||||
objective | Key objective | STRING | None | None | ||||
plans | Plans or Strategies | 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] |