Created
February 19, 2026 00:10
-
-
Save dragonsahead/114190b6a557ca9192801ad2a135c016 to your computer and use it in GitHub Desktop.
Metadata
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Card metadata | |
| <details> | |
| { | |
| "cache_invalidated_at": null, | |
| "description": null, | |
| "archived": false, | |
| "view_count": 24, | |
| "collection_position": null, | |
| "source_card_id": 236, | |
| "table_id": 718, | |
| "can_run_adhoc_query": true, | |
| "result_metadata": [ | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Location", | |
| "lib/original-name": "Location", | |
| "lib/breakout?": false, | |
| "name": "Location", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Location", | |
| "lib/original-display-name": "Location", | |
| "lib/model-display-name": "Location", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26757, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26757, | |
| "lib/desired-column-alias": "Location", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Location", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 7 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Year", | |
| "lib/original-name": "Year", | |
| "lib/breakout?": false, | |
| "name": "Year", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Year", | |
| "lib/original-display-name": "Year", | |
| "settings": { | |
| "number_separators": "." | |
| }, | |
| "lib/model-display-name": "Year", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26758, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26758, | |
| "lib/desired-column-alias": "Year", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Month", | |
| "lib/original-name": "Month", | |
| "lib/breakout?": false, | |
| "name": "Month", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Month", | |
| "lib/original-display-name": "Month", | |
| "lib/model-display-name": "Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26759, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26759, | |
| "lib/desired-column-alias": "Month", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month_num", | |
| "lib/original-name": "month_num", | |
| "lib/breakout?": false, | |
| "name": "month_num", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month_num", | |
| "lib/original-display-name": "Month Num", | |
| "lib/model-display-name": "Month Num", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26760, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26760, | |
| "lib/desired-column-alias": "month_num", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Month Num", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 3.5, | |
| "q3": 9.5, | |
| "max": 12, | |
| "sd": 3.4762777567757044, | |
| "avg": 6.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Category", | |
| "lib/original-name": "Category", | |
| "lib/breakout?": false, | |
| "name": "Category", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Category", | |
| "lib/original-display-name": "Category", | |
| "lib/model-display-name": "Category", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26761, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26761, | |
| "lib/desired-column-alias": "Category", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Category", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 17 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Measure", | |
| "lib/original-name": "Measure", | |
| "lib/breakout?": false, | |
| "name": "Measure", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Measure", | |
| "lib/original-display-name": "Measure", | |
| "lib/model-display-name": "Measure", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26762, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26762, | |
| "lib/desired-column-alias": "Measure", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Measure", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 5.333333333333333 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "numeric", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Value", | |
| "lib/original-name": "Value", | |
| "lib/breakout?": false, | |
| "name": "Value", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Value", | |
| "lib/original-display-name": "Value", | |
| "lib/model-display-name": "Value", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26763, | |
| null | |
| ], | |
| "effective_type": "type/Decimal", | |
| "active": true, | |
| "id": 26763, | |
| "lib/desired-column-alias": "Value", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Value", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 35, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0, | |
| "q1": 24767.271450907512, | |
| "q3": 154409.5, | |
| "max": 245675.55, | |
| "sd": 77987.6991741083, | |
| "avg": 101883.4786111111 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Decimal" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "creator": { | |
| "email": "redacted", | |
| "first_name": "Admin", | |
| "last_login": "2026-02-16T18:28:18.064117Z", | |
| "is_qbnewb": false, | |
| "is_superuser": true, | |
| "id": 12, | |
| "last_name": "DevOps", | |
| "tenant_id": null, | |
| "date_joined": "2026-02-05T14:11:22.290928Z", | |
| "common_name": "Admin DevOps" | |
| }, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "name": "Operating Expenses (1)", | |
| "last_query_start": "2026-02-16T18:35:25.901844Z", | |
| "is_remote_synced": false, | |
| "dashboard_count": 1, | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T18:35:25.952785Z", | |
| "dashboard": null, | |
| "type": "question", | |
| "average_query_time": 199.95652173913044, | |
| "creator_id": 12, | |
| "can_restore": false, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T18:40:56.460311Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "source-card": 236, | |
| "lib/type": "mbql.stage/mbql", | |
| "order-by": [ | |
| [ | |
| "asc", | |
| { | |
| "lib/uuid": "aa8befc9-b1e7-4031-a1d3-0d233ff86b72" | |
| }, | |
| [ | |
| "field", | |
| { | |
| "effective-type": "type/Integer", | |
| "lib/uuid": "7a8cf827-7a9e-4c3c-9d40-497a1d7562c0", | |
| "base-type": "type/Integer" | |
| }, | |
| "month_num" | |
| ] | |
| ] | |
| ] | |
| } | |
| ] | |
| }, | |
| "id": 247, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "can_manage_db": true, | |
| "display": "combo", | |
| "archived_directly": false, | |
| "entity_id": "8GjaSvJTtKd_N6g3NlvDh", | |
| "collection_preview": true, | |
| "last-edit-info": { | |
| "id": 12, | |
| "email": "redacted", | |
| "first_name": "Admin", | |
| "last_name": "DevOps", | |
| "timestamp": "2026-02-11T18:40:56.451263Z" | |
| }, | |
| "visualization_settings": { | |
| "graph.dimensions": [ | |
| "Month", | |
| "Category" | |
| ], | |
| "graph.series_order_dimension": null, | |
| "graph.series_order": null, | |
| "series_settings": { | |
| "current_year_total": { | |
| "title": "Current Year", | |
| "display": "bar" | |
| }, | |
| "monthly_budget": { | |
| "title": "Budget", | |
| "display": "line", | |
| "line.interpolate": "cardinal" | |
| }, | |
| "previous_year_total": { | |
| "display": "line", | |
| "title": "Previous Year", | |
| "line.interpolate": "linear" | |
| } | |
| }, | |
| "graph.x_axis.scale": "ordinal", | |
| "graph.metrics": [ | |
| "Value" | |
| ] | |
| }, | |
| "collection": { | |
| "authority_level": null, | |
| "description": null, | |
| "archived": false, | |
| "slug": "centerrock", | |
| "archive_operation_id": null, | |
| "name": "CenterRock", | |
| "is_remote_synced": false, | |
| "personal_owner_id": null, | |
| "type": null, | |
| "is_sample": false, | |
| "id": 20, | |
| "archived_directly": null, | |
| "entity_id": "gcgiPnfQxUCmqzWusba1T", | |
| "location": "/5/", | |
| "namespace": null, | |
| "is_personal": false, | |
| "created_at": "2025-10-06T16:33:48.661221Z" | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-11T18:40:56.435289Z", | |
| "parameter_usage_count": 0, | |
| "public_uuid": null, | |
| "can_delete": false | |
| } | |
| </details> | |
| Dashboard metadata | |
| <details> | |
| { | |
| "description": null, | |
| "archived": false, | |
| "view_count": 117, | |
| "collection_position": 1, | |
| "dashcards": [ | |
| { | |
| "size_x": 12, | |
| "dashboard_tab_id": 21, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": null, | |
| "description": null, | |
| "archived": false, | |
| "view_count": 34, | |
| "collection_position": null, | |
| "source_card_id": 242, | |
| "table_id": 763, | |
| "result_metadata": [ | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "year", | |
| "lib/original-name": "year", | |
| "lib/breakout?": false, | |
| "name": "year", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "year", | |
| "lib/original-display-name": "Year", | |
| "lib/model-display-name": "Year", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26875, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26875, | |
| "lib/desired-column-alias": "year", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month", | |
| "lib/original-name": "month", | |
| "lib/breakout?": false, | |
| "name": "month", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month", | |
| "lib/original-display-name": "Month", | |
| "lib/model-display-name": "Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26876, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26876, | |
| "lib/desired-column-alias": "month", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month_num", | |
| "lib/original-name": "month_num", | |
| "lib/breakout?": false, | |
| "name": "month_num", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month_num", | |
| "lib/original-display-name": "Month Num", | |
| "lib/model-display-name": "Month Num", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26877, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26877, | |
| "lib/desired-column-alias": "month_num", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Month Num", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 3.5, | |
| "q3": 9.5, | |
| "max": 12, | |
| "sd": 3.605551275463989, | |
| "avg": 6.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "aggregated_actual_otd", | |
| "lib/original-name": "aggregated_actual_otd", | |
| "lib/breakout?": false, | |
| "name": "aggregated_actual_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "aggregated_actual_otd", | |
| "lib/original-display-name": "Aggregated Actual Otd", | |
| "lib/model-display-name": "Aggregated Actual Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26878, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26878, | |
| "lib/desired-column-alias": "aggregated_actual_otd", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Aggregated Actual Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 9, | |
| "nil%": 0.3333333333333333 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0.11, | |
| "q1": 0.11525704809286899, | |
| "q3": 0.15862242332830567, | |
| "max": 0.3, | |
| "sd": 0.06226966988697329, | |
| "avg": 0.1533683085914319 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "average_target_otd", | |
| "lib/original-name": "average_target_otd", | |
| "lib/breakout?": false, | |
| "name": "average_target_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "average_target_otd", | |
| "lib/original-display-name": "Average Target Otd", | |
| "lib/model-display-name": "Average Target Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26879, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26879, | |
| "lib/desired-column-alias": "average_target_otd", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Average Target Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0.85, | |
| "q1": 0.85, | |
| "q3": 0.85, | |
| "max": 0.85, | |
| "sd": 0, | |
| "avg": 0.85 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "aggregated_previous_year_otd", | |
| "lib/original-name": "aggregated_previous_year_otd", | |
| "lib/breakout?": false, | |
| "name": "aggregated_previous_year_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "aggregated_previous_year_otd", | |
| "lib/original-display-name": "Aggregated Previous Year Otd", | |
| "lib/model-display-name": "Aggregated Previous Year Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26880, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26880, | |
| "lib/desired-column-alias": "aggregated_previous_year_otd", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Aggregated Previous Year Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": null, | |
| "q1": null, | |
| "q3": null, | |
| "max": null, | |
| "sd": null, | |
| "avg": null | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Flanders Service Otd Monthly Level1 - Modified", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T14:16:40.74283Z", | |
| "type": "question", | |
| "query_average_duration": 31, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-12T16:26:03.028878Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "lib/type": "mbql.stage/mbql", | |
| "source-card": 242 | |
| } | |
| ] | |
| }, | |
| "id": 250, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "table", | |
| "archived_directly": false, | |
| "entity_id": "IxQ9djIQzabjzJyuQjNKi", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "table.pivot_column": "year", | |
| "table.cell_column": "month_num", | |
| "column_settings": { | |
| "[\"name\",\"aggregated_actual_otd\"]": { | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"average_target_otd\"]": { | |
| "show_mini_bar": false, | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"aggregated_previous_year_otd\"]": { | |
| "number_style": "percent", | |
| "number_separators": ".,", | |
| "decimals": 0 | |
| } | |
| } | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-12T16:26:03.001455Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-12T17:07:10.62315Z", | |
| "col": 0, | |
| "id": 209, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 250, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 250, | |
| "entity_id": "EbZ88OkbarKWOQxXPfB41", | |
| "visualization_settings": { | |
| "visualization": { | |
| "display": "bar", | |
| "columnValuesMapping": { | |
| "COLUMN_2": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "month", | |
| "name": "COLUMN_2" | |
| } | |
| ], | |
| "COLUMN_3": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "aggregated_actual_otd", | |
| "name": "COLUMN_3" | |
| } | |
| ], | |
| "COLUMN_4": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "average_target_otd", | |
| "name": "COLUMN_4" | |
| } | |
| ], | |
| "COLUMN_5": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "aggregated_previous_year_otd", | |
| "name": "COLUMN_5" | |
| } | |
| ] | |
| }, | |
| "settings": { | |
| "table.pivot_column": "year", | |
| "table.cell_column": "month_num", | |
| "column_settings": { | |
| "[\"name\",\"aggregated_actual_otd\"]": { | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"average_target_otd\"]": { | |
| "show_mini_bar": false, | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"aggregated_previous_year_otd\"]": { | |
| "number_style": "percent", | |
| "number_separators": ".,", | |
| "decimals": 0 | |
| } | |
| }, | |
| "graph.dimensions": [ | |
| "COLUMN_2" | |
| ], | |
| "graph.metrics": [ | |
| "COLUMN_3", | |
| "COLUMN_4", | |
| "COLUMN_5" | |
| ], | |
| "series_settings": { | |
| "COLUMN_3": { | |
| "title": "Actual OTD", | |
| "color": "#ED8535" | |
| }, | |
| "COLUMN_4": { | |
| "title": "Target", | |
| "display": "line", | |
| "color": "#227FD2" | |
| }, | |
| "COLUMN_5": { | |
| "title": "Previous Year OTD", | |
| "display": "line" | |
| } | |
| }, | |
| "card.title": "Service On Time Delivery" | |
| } | |
| } | |
| }, | |
| "size_y": 7, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-06T16:07:31.748852Z", | |
| "row": 0 | |
| }, | |
| { | |
| "size_x": 12, | |
| "dashboard_tab_id": 21, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": null, | |
| "description": null, | |
| "archived": false, | |
| "view_count": 34, | |
| "collection_position": null, | |
| "source_card_id": 242, | |
| "table_id": 763, | |
| "result_metadata": [ | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "year", | |
| "lib/original-name": "year", | |
| "lib/breakout?": false, | |
| "name": "year", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "year", | |
| "lib/original-display-name": "Year", | |
| "lib/model-display-name": "Year", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26875, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26875, | |
| "lib/desired-column-alias": "year", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month", | |
| "lib/original-name": "month", | |
| "lib/breakout?": false, | |
| "name": "month", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month", | |
| "lib/original-display-name": "Month", | |
| "lib/model-display-name": "Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26876, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26876, | |
| "lib/desired-column-alias": "month", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month_num", | |
| "lib/original-name": "month_num", | |
| "lib/breakout?": false, | |
| "name": "month_num", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month_num", | |
| "lib/original-display-name": "Month Num", | |
| "lib/model-display-name": "Month Num", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26877, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26877, | |
| "lib/desired-column-alias": "month_num", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Month Num", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 3.5, | |
| "q3": 9.5, | |
| "max": 12, | |
| "sd": 3.605551275463989, | |
| "avg": 6.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "aggregated_actual_otd", | |
| "lib/original-name": "aggregated_actual_otd", | |
| "lib/breakout?": false, | |
| "name": "aggregated_actual_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "aggregated_actual_otd", | |
| "lib/original-display-name": "Aggregated Actual Otd", | |
| "lib/model-display-name": "Aggregated Actual Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26878, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26878, | |
| "lib/desired-column-alias": "aggregated_actual_otd", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Aggregated Actual Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 9, | |
| "nil%": 0.3333333333333333 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0.11, | |
| "q1": 0.11525704809286899, | |
| "q3": 0.15862242332830567, | |
| "max": 0.3, | |
| "sd": 0.06226966988697329, | |
| "avg": 0.1533683085914319 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "average_target_otd", | |
| "lib/original-name": "average_target_otd", | |
| "lib/breakout?": false, | |
| "name": "average_target_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "average_target_otd", | |
| "lib/original-display-name": "Average Target Otd", | |
| "lib/model-display-name": "Average Target Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26879, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26879, | |
| "lib/desired-column-alias": "average_target_otd", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Average Target Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0.85, | |
| "q1": 0.85, | |
| "q3": 0.85, | |
| "max": 0.85, | |
| "sd": 0, | |
| "avg": 0.85 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "database_type": "float8", | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "aggregated_previous_year_otd", | |
| "lib/original-name": "aggregated_previous_year_otd", | |
| "lib/breakout?": false, | |
| "name": "aggregated_previous_year_otd", | |
| "lib/card-id": 242, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "aggregated_previous_year_otd", | |
| "lib/original-display-name": "Aggregated Previous Year Otd", | |
| "lib/model-display-name": "Aggregated Previous Year Otd", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26880, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 26880, | |
| "lib/desired-column-alias": "aggregated_previous_year_otd", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Aggregated Previous Year Otd", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": null, | |
| "q1": null, | |
| "q3": null, | |
| "max": null, | |
| "sd": null, | |
| "avg": null | |
| } | |
| } | |
| }, | |
| "base_type": "type/Float" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Flanders Service Otd Monthly Level1 - Modified", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T14:16:40.74283Z", | |
| "type": "question", | |
| "query_average_duration": 31, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-12T16:26:03.028878Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "lib/type": "mbql.stage/mbql", | |
| "source-card": 242 | |
| } | |
| ] | |
| }, | |
| "id": 250, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "table", | |
| "archived_directly": false, | |
| "entity_id": "IxQ9djIQzabjzJyuQjNKi", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "table.pivot_column": "year", | |
| "table.cell_column": "month_num", | |
| "column_settings": { | |
| "[\"name\",\"aggregated_actual_otd\"]": { | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"average_target_otd\"]": { | |
| "show_mini_bar": false, | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"aggregated_previous_year_otd\"]": { | |
| "number_style": "percent", | |
| "number_separators": ".,", | |
| "decimals": 0 | |
| } | |
| } | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-12T16:26:03.001455Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-12T17:08:18.837104Z", | |
| "col": 12, | |
| "id": 210, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 250, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 250, | |
| "entity_id": "0yXSGXKr_lTpWcE2Rm1_c", | |
| "visualization_settings": { | |
| "visualization": { | |
| "display": "bar", | |
| "columnValuesMapping": { | |
| "COLUMN_2": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "month", | |
| "name": "COLUMN_2" | |
| } | |
| ], | |
| "COLUMN_3": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "aggregated_actual_otd", | |
| "name": "COLUMN_3" | |
| } | |
| ], | |
| "COLUMN_4": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "average_target_otd", | |
| "name": "COLUMN_4" | |
| } | |
| ], | |
| "COLUMN_5": [ | |
| { | |
| "sourceId": "card:250", | |
| "originalName": "aggregated_previous_year_otd", | |
| "name": "COLUMN_5" | |
| } | |
| ] | |
| }, | |
| "settings": { | |
| "table.pivot_column": "year", | |
| "table.cell_column": "month_num", | |
| "column_settings": { | |
| "[\"name\",\"aggregated_actual_otd\"]": { | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"average_target_otd\"]": { | |
| "show_mini_bar": false, | |
| "number_style": "percent" | |
| }, | |
| "[\"name\",\"aggregated_previous_year_otd\"]": { | |
| "number_style": "percent", | |
| "number_separators": ".,", | |
| "decimals": 0 | |
| } | |
| }, | |
| "graph.dimensions": [ | |
| "COLUMN_2" | |
| ], | |
| "graph.metrics": [ | |
| "COLUMN_3", | |
| "COLUMN_4", | |
| "COLUMN_5" | |
| ] | |
| } | |
| } | |
| }, | |
| "size_y": 7, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-06T16:18:04.474592Z", | |
| "row": 0 | |
| }, | |
| { | |
| "size_x": 24, | |
| "dashboard_tab_id": 21, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": "2026-02-11T18:20:31.483863Z", | |
| "description": null, | |
| "archived": false, | |
| "view_count": 168, | |
| "collection_position": 7, | |
| "source_card_id": null, | |
| "table_id": 758, | |
| "result_metadata": [ | |
| { | |
| "database_type": "int8", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "overall_seq_no", | |
| "lib/original-name": "overall_seq_no", | |
| "lib/breakout?": false, | |
| "name": "overall_seq_no", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "overall_seq_no", | |
| "lib/original-display-name": "Overall Seq No", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26811, | |
| null | |
| ], | |
| "effective_type": "type/BigInteger", | |
| "active": true, | |
| "id": 26811, | |
| "lib/desired-column-alias": "overall_seq_no", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Overall Seq No", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 2.25, | |
| "q3": 5.75, | |
| "max": 7, | |
| "sd": 2.0754980866510833, | |
| "avg": 4 | |
| } | |
| } | |
| }, | |
| "base_type": "type/BigInteger" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "idea_no", | |
| "lib/original-name": "idea_no", | |
| "lib/breakout?": false, | |
| "name": "idea_no", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "idea_no", | |
| "lib/original-display-name": "Idea No", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26812, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26812, | |
| "lib/desired-column-alias": "idea_no", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Idea No", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 14, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 3, | |
| "q1": 7, | |
| "q3": 42, | |
| "max": 51, | |
| "sd": 18.615248387477198, | |
| "avg": 29.285714285714285 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "location", | |
| "lib/original-name": "location", | |
| "lib/breakout?": false, | |
| "name": "location", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "location", | |
| "lib/original-display-name": "Location", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26813, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26813, | |
| "lib/desired-column-alias": "location", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Location", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 7 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "kpi", | |
| "lib/original-name": "kpi", | |
| "lib/breakout?": false, | |
| "name": "kpi", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "kpi", | |
| "lib/original-display-name": "Kpi", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26814, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26814, | |
| "lib/desired-column-alias": "kpi", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Kpi", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 19 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "sub_kpi", | |
| "lib/original-name": "sub_kpi", | |
| "lib/breakout?": false, | |
| "name": "sub_kpi", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "sub_kpi", | |
| "lib/original-display-name": "Sub Kpi", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26815, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26815, | |
| "lib/desired-column-alias": "sub_kpi", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Sub Kpi", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 14.142857142857142 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/CreationDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "open_date", | |
| "lib/original-name": "open_date", | |
| "lib/breakout?": false, | |
| "name": "open_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "open_date", | |
| "lib/original-display-name": "Open Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY" | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26816, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26816, | |
| "lib/desired-column-alias": "open_date", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Open Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": "2025-10-13", | |
| "latest": "2025-10-13" | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Description", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "problem_description", | |
| "lib/original-name": "problem_description", | |
| "lib/breakout?": false, | |
| "name": "problem_description", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "problem_description", | |
| "lib/original-display-name": "Problem Description", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26817, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26817, | |
| "lib/desired-column-alias": "problem_description", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Problem Description", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 5.785714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "root_cause_seq", | |
| "lib/original-name": "root_cause_seq", | |
| "lib/breakout?": false, | |
| "name": "root_cause_seq", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "root_cause_seq", | |
| "lib/original-display-name": "Root Cause Seq", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26818, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26818, | |
| "lib/desired-column-alias": "root_cause_seq", | |
| "position": 7, | |
| "visibility_type": "normal", | |
| "display_name": "Root Cause Seq", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 12 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "root_cause", | |
| "lib/original-name": "root_cause", | |
| "lib/breakout?": false, | |
| "name": "root_cause", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "root_cause", | |
| "lib/original-display-name": "Root Cause", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26819, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26819, | |
| "lib/desired-column-alias": "root_cause", | |
| "position": 8, | |
| "visibility_type": "normal", | |
| "display_name": "Root Cause", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 14.857142857142858 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "countermeasure", | |
| "lib/original-name": "countermeasure", | |
| "lib/breakout?": false, | |
| "name": "countermeasure", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "countermeasure", | |
| "lib/original-display-name": "Countermeasure", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26820, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26820, | |
| "lib/desired-column-alias": "countermeasure", | |
| "position": 9, | |
| "visibility_type": "normal", | |
| "display_name": "Countermeasure", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 8.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "assignee", | |
| "lib/original-name": "assignee", | |
| "lib/breakout?": false, | |
| "name": "assignee", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "assignee", | |
| "lib/original-display-name": "Assignee", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26821, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26821, | |
| "lib/desired-column-alias": "assignee", | |
| "position": 10, | |
| "visibility_type": "normal", | |
| "display_name": "Assignee", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "expected_outcome", | |
| "lib/original-name": "expected_outcome", | |
| "lib/breakout?": false, | |
| "name": "expected_outcome", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "expected_outcome", | |
| "lib/original-display-name": "Expected Outcome", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26822, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26822, | |
| "lib/desired-column-alias": "expected_outcome", | |
| "position": 11, | |
| "visibility_type": "normal", | |
| "display_name": "Expected Outcome", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 8.285714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/CreationDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "target_completion_date", | |
| "lib/original-name": "target_completion_date", | |
| "lib/breakout?": false, | |
| "name": "target_completion_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "target_completion_date", | |
| "lib/original-display-name": "Target Completion Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY" | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26823, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26823, | |
| "lib/desired-column-alias": "target_completion_date", | |
| "position": 12, | |
| "visibility_type": "normal", | |
| "display_name": "Target Completion Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": "2025-10-31", | |
| "latest": "2025-12-31" | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/UpdatedDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "updated_completion_date", | |
| "lib/original-name": "updated_completion_date", | |
| "lib/breakout?": false, | |
| "name": "updated_completion_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "updated_completion_date", | |
| "lib/original-display-name": "Updated Completion Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY", | |
| "closure_uid_754409280": 1075 | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26824, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26824, | |
| "lib/desired-column-alias": "updated_completion_date", | |
| "position": 13, | |
| "visibility_type": "normal", | |
| "display_name": "Updated Completion Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": null, | |
| "latest": null | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "verify", | |
| "lib/original-name": "verify", | |
| "lib/breakout?": false, | |
| "name": "verify", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "verify", | |
| "lib/original-display-name": "Verify", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26825, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26825, | |
| "lib/desired-column-alias": "verify", | |
| "position": 14, | |
| "visibility_type": "normal", | |
| "display_name": "Verify", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0.9285714285714286 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0.9285714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "status", | |
| "lib/original-name": "status", | |
| "lib/breakout?": false, | |
| "name": "status", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "status", | |
| "lib/original-display-name": "Status", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26826, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26826, | |
| "lib/desired-column-alias": "status", | |
| "position": 15, | |
| "visibility_type": "normal", | |
| "display_name": "Status", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0.6428571428571429 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_year", | |
| "lib/original-name": "pareto_year", | |
| "lib/breakout?": false, | |
| "name": "pareto_year", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_year", | |
| "lib/original-display-name": "Pareto Year", | |
| "settings": { | |
| "number_separators": "." | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26827, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26827, | |
| "lib/desired-column-alias": "pareto_year", | |
| "position": 16, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_month", | |
| "lib/original-name": "pareto_month", | |
| "lib/breakout?": false, | |
| "name": "pareto_month", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_month", | |
| "lib/original-display-name": "Pareto Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26828, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26828, | |
| "lib/desired-column-alias": "pareto_month", | |
| "position": 17, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "numeric", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_amount", | |
| "lib/original-name": "pareto_amount", | |
| "lib/breakout?": false, | |
| "name": "pareto_amount", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_amount", | |
| "lib/original-display-name": "Pareto Amount", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26829, | |
| null | |
| ], | |
| "effective_type": "type/Decimal", | |
| "active": true, | |
| "id": 26829, | |
| "lib/desired-column-alias": "pareto_amount", | |
| "position": 18, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Amount", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 14, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 687.75, | |
| "q1": 5772.5, | |
| "q3": 23095, | |
| "max": 101179.17, | |
| "sd": 30314.958093734684, | |
| "avg": 23419.851428571426 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Decimal" | |
| }, | |
| { | |
| "database_type": "int8", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "subkpi_rank", | |
| "lib/original-name": "subkpi_rank", | |
| "lib/breakout?": false, | |
| "name": "subkpi_rank", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "subkpi_rank", | |
| "lib/original-display-name": "Subkpi Rank", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26830, | |
| null | |
| ], | |
| "effective_type": "type/BigInteger", | |
| "active": true, | |
| "id": 26830, | |
| "lib/desired-column-alias": "subkpi_rank", | |
| "position": 19, | |
| "visibility_type": "normal", | |
| "display_name": "Subkpi Rank", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 2.25, | |
| "q3": 5.75, | |
| "max": 7, | |
| "sd": 2.0754980866510833, | |
| "avg": 4 | |
| } | |
| } | |
| }, | |
| "base_type": "type/BigInteger" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Flanders - Operating Expense - PDCA - Level1 - Ranked By Pareto", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T18:37:52.661484Z", | |
| "type": "model", | |
| "query_average_duration": 984, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T18:28:22.71767Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "lib/type": "mbql.stage/mbql", | |
| "source-table": 758 | |
| } | |
| ] | |
| }, | |
| "id": 241, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "table", | |
| "archived_directly": false, | |
| "entity_id": "DQvuttN_ZnDLAIVwhHNFt", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "table.pivot_column": "kpi", | |
| "table.cell_column": "overall_seq_no" | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-06T19:07:37.097029Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-12T17:08:46.672771Z", | |
| "col": 0, | |
| "id": 212, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 241, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "pareto_year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "parameter_id": "f9a5b8f4", | |
| "card_id": 241, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "location", | |
| { | |
| "base-type": "type/Text" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 241, | |
| "entity_id": "X8IhpuCKQY8zhxmJ7LmgY", | |
| "visualization_settings": { | |
| "table.pivot_column": "kpi", | |
| "table.cell_column": "overall_seq_no", | |
| "table.columns": [ | |
| { | |
| "name": "overall_seq_no", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "idea_no", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "location", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "kpi", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "sub_kpi", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "open_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "problem_description", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "root_cause_seq", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "root_cause", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "countermeasure", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "assignee", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "expected_outcome", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "target_completion_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "updated_completion_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "verify", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "pareto_year", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "status", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "pareto_month", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "pareto_amount", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "subkpi_rank", | |
| "enabled": false | |
| } | |
| ], | |
| "card.title": "", | |
| "table.column_widths": [ | |
| 76, | |
| null, | |
| null, | |
| 200, | |
| 234, | |
| 205, | |
| 101, | |
| 232, | |
| 134, | |
| 136, | |
| 109, | |
| 86 | |
| ], | |
| "column_settings": { | |
| "[\"name\",\"problem_description\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"root_cause\"]": { | |
| "column_title": "Potential Root Cause", | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"countermeasure\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"expected_outcome\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"verify\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"status\"]": { | |
| "text_wrapping": true | |
| } | |
| } | |
| }, | |
| "size_y": 8, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T18:17:02.654402Z", | |
| "row": 7 | |
| }, | |
| { | |
| "size_x": 12, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": "2026-02-11T19:10:23.673036Z", | |
| "description": null, | |
| "archived": false, | |
| "view_count": 125, | |
| "collection_position": null, | |
| "source_card_id": 237, | |
| "table_id": 749, | |
| "result_metadata": [ | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Location", | |
| "lib/original-name": "Location", | |
| "lib/breakout?": false, | |
| "name": "Location", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Location", | |
| "lib/original-display-name": "Location", | |
| "lib/model-display-name": "Location", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26764, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26764, | |
| "lib/desired-column-alias": "Location", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Location", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 7 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Year", | |
| "lib/original-name": "Year", | |
| "lib/breakout?": false, | |
| "name": "Year", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Year", | |
| "lib/original-display-name": "Year", | |
| "lib/model-display-name": "Year", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26765, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26765, | |
| "lib/desired-column-alias": "Year", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Month", | |
| "lib/original-name": "Month", | |
| "lib/breakout?": false, | |
| "name": "Month", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Month", | |
| "lib/original-display-name": "Month", | |
| "lib/model-display-name": "Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26766, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26766, | |
| "lib/desired-column-alias": "Month", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Month Num", | |
| "lib/original-name": "Month Num", | |
| "lib/breakout?": false, | |
| "name": "Month Num", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Month Num", | |
| "lib/original-display-name": "Month Num", | |
| "lib/model-display-name": "Month Num", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26767, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26767, | |
| "lib/desired-column-alias": "Month Num", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Month Num", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 12, | |
| "q1": 12, | |
| "q3": 12, | |
| "max": 12, | |
| "sd": 0, | |
| "avg": 12 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Type", | |
| "lib/original-name": "Type", | |
| "lib/breakout?": false, | |
| "name": "Type", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Type", | |
| "lib/original-display-name": "Type", | |
| "lib/model-display-name": "Type", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26768, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26768, | |
| "lib/desired-column-alias": "Type", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Type", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 14.142857142857142 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int8", | |
| "semantic_type": null, | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Type Seq No", | |
| "lib/original-name": "Type Seq No", | |
| "lib/breakout?": false, | |
| "name": "Type Seq No", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Type Seq No", | |
| "lib/original-display-name": "Type Seq No", | |
| "lib/model-display-name": "Type Seq No", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26769, | |
| null | |
| ], | |
| "effective_type": "type/BigInteger", | |
| "active": true, | |
| "id": 26769, | |
| "lib/desired-column-alias": "Type Seq No", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Type Seq No", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 2.25, | |
| "q3": 5.75, | |
| "max": 7, | |
| "sd": 2.0367003088692623, | |
| "avg": 4 | |
| } | |
| } | |
| }, | |
| "base_type": "type/BigInteger" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Measure", | |
| "lib/original-name": "Measure", | |
| "lib/breakout?": false, | |
| "name": "Measure", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Measure", | |
| "lib/original-display-name": "Measure", | |
| "lib/model-display-name": "Measure", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26770, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26770, | |
| "lib/desired-column-alias": "Measure", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Measure", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 8.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "numeric", | |
| "semantic_type": null, | |
| "table_id": 749, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Value", | |
| "lib/original-name": "Value", | |
| "lib/breakout?": false, | |
| "name": "Value", | |
| "lib/card-id": 237, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Value", | |
| "lib/original-display-name": "Value", | |
| "lib/model-display-name": "Value", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26771, | |
| null | |
| ], | |
| "effective_type": "type/Decimal", | |
| "active": true, | |
| "id": 26771, | |
| "lib/desired-column-alias": "Value", | |
| "position": 7, | |
| "visibility_type": "normal", | |
| "display_name": "Value", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 28, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 687.75, | |
| "q1": 6464.585, | |
| "q3": 27577.5, | |
| "max": 117012, | |
| "sd": 31681.08546253385, | |
| "avg": 26786.354285714282 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Decimal" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Operating Expense Pareto Level -1", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T18:37:52.661484Z", | |
| "type": "question", | |
| "query_average_duration": 316, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T19:10:23.672812Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "source-card": 237, | |
| "lib/type": "mbql.stage/mbql", | |
| "order-by": [ | |
| [ | |
| "asc", | |
| { | |
| "lib/uuid": "447e2237-386f-4c89-a545-7e0668f0d118" | |
| }, | |
| [ | |
| "field", | |
| { | |
| "effective-type": "type/BigInteger", | |
| "lib/uuid": "db927b90-972f-483b-a644-ef0bdd1651a1", | |
| "base-type": "type/BigInteger" | |
| }, | |
| "Type Seq No" | |
| ] | |
| ] | |
| ] | |
| } | |
| ] | |
| }, | |
| "id": 239, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "bar", | |
| "archived_directly": false, | |
| "entity_id": "X5gAkhkQxQioH2Tc_Uw54", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "graph.dimensions": [ | |
| "Type", | |
| "Measure" | |
| ], | |
| "graph.series_order_dimension": "Measure", | |
| "graph.series_order": [ | |
| { | |
| "key": "6 month avg", | |
| "color": "#509EE3", | |
| "enabled": true, | |
| "name": "6 month avg" | |
| }, | |
| { | |
| "key": "amount", | |
| "color": "#88BF4D", | |
| "enabled": true, | |
| "name": "amount" | |
| } | |
| ], | |
| "graph.x_axis.scale": "ordinal", | |
| "series_settings": { | |
| "6 month avg": { | |
| "title": "6 Month avg" | |
| }, | |
| "amount": { | |
| "title": "Current Month Total", | |
| "color": "#A7D07C" | |
| } | |
| }, | |
| "graph.metrics": [ | |
| "Value" | |
| ] | |
| }, | |
| "metabase_version": "v1.58.1 (7fbf305)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-06T16:17:21.560725Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-11T20:03:13.983963Z", | |
| "col": 12, | |
| "id": 214, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 239, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "Year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "parameter_id": "f9a5b8f4", | |
| "card_id": 239, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "Location", | |
| { | |
| "base-type": "type/Text" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 239, | |
| "entity_id": "WnyoyuMANsMU1a86Yw-qb", | |
| "visualization_settings": { | |
| "visualization": { | |
| "display": "combo", | |
| "columnValuesMapping": { | |
| "COLUMN_1": [ | |
| { | |
| "sourceId": "card:239", | |
| "originalName": "Type", | |
| "name": "COLUMN_1" | |
| } | |
| ], | |
| "COLUMN_2": [ | |
| { | |
| "sourceId": "card:239", | |
| "originalName": "Measure", | |
| "name": "COLUMN_2" | |
| } | |
| ], | |
| "COLUMN_3": [ | |
| { | |
| "sourceId": "card:239", | |
| "originalName": "Value", | |
| "name": "COLUMN_3" | |
| } | |
| ] | |
| }, | |
| "settings": { | |
| "graph.dimensions": [ | |
| "COLUMN_1", | |
| "COLUMN_2" | |
| ], | |
| "graph.series_order_dimension": "COLUMN_2", | |
| "graph.series_order": [ | |
| { | |
| "key": "6 month avg", | |
| "color": "#509EE3", | |
| "enabled": true, | |
| "name": "6 month avg" | |
| }, | |
| { | |
| "key": "amount", | |
| "color": "#88BF4D", | |
| "enabled": true, | |
| "name": "amount" | |
| } | |
| ], | |
| "series_settings": { | |
| "6 month avg": { | |
| "display": "bar" | |
| } | |
| }, | |
| "graph.x_axis.scale": "ordinal", | |
| "graph.metrics": [ | |
| "COLUMN_3" | |
| ], | |
| "card.title": "Operating Expense Categories Pareto" | |
| } | |
| } | |
| }, | |
| "size_y": 6, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T18:30:20.315875Z", | |
| "row": 0 | |
| }, | |
| { | |
| "size_x": 24, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": "2026-02-11T18:20:31.483863Z", | |
| "description": null, | |
| "archived": false, | |
| "view_count": 168, | |
| "collection_position": 7, | |
| "source_card_id": null, | |
| "table_id": 758, | |
| "result_metadata": [ | |
| { | |
| "database_type": "int8", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "overall_seq_no", | |
| "lib/original-name": "overall_seq_no", | |
| "lib/breakout?": false, | |
| "name": "overall_seq_no", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "overall_seq_no", | |
| "lib/original-display-name": "Overall Seq No", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26811, | |
| null | |
| ], | |
| "effective_type": "type/BigInteger", | |
| "active": true, | |
| "id": 26811, | |
| "lib/desired-column-alias": "overall_seq_no", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Overall Seq No", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 2.25, | |
| "q3": 5.75, | |
| "max": 7, | |
| "sd": 2.0754980866510833, | |
| "avg": 4 | |
| } | |
| } | |
| }, | |
| "base_type": "type/BigInteger" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "idea_no", | |
| "lib/original-name": "idea_no", | |
| "lib/breakout?": false, | |
| "name": "idea_no", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "idea_no", | |
| "lib/original-display-name": "Idea No", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26812, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26812, | |
| "lib/desired-column-alias": "idea_no", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Idea No", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 14, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 3, | |
| "q1": 7, | |
| "q3": 42, | |
| "max": 51, | |
| "sd": 18.615248387477198, | |
| "avg": 29.285714285714285 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "location", | |
| "lib/original-name": "location", | |
| "lib/breakout?": false, | |
| "name": "location", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "location", | |
| "lib/original-display-name": "Location", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26813, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26813, | |
| "lib/desired-column-alias": "location", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Location", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 7 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "kpi", | |
| "lib/original-name": "kpi", | |
| "lib/breakout?": false, | |
| "name": "kpi", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "kpi", | |
| "lib/original-display-name": "Kpi", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26814, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26814, | |
| "lib/desired-column-alias": "kpi", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Kpi", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 19 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "sub_kpi", | |
| "lib/original-name": "sub_kpi", | |
| "lib/breakout?": false, | |
| "name": "sub_kpi", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "sub_kpi", | |
| "lib/original-display-name": "Sub Kpi", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26815, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26815, | |
| "lib/desired-column-alias": "sub_kpi", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Sub Kpi", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 14.142857142857142 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/CreationDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "open_date", | |
| "lib/original-name": "open_date", | |
| "lib/breakout?": false, | |
| "name": "open_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "open_date", | |
| "lib/original-display-name": "Open Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY" | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26816, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26816, | |
| "lib/desired-column-alias": "open_date", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Open Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": "2025-10-13", | |
| "latest": "2025-10-13" | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Description", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "problem_description", | |
| "lib/original-name": "problem_description", | |
| "lib/breakout?": false, | |
| "name": "problem_description", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "problem_description", | |
| "lib/original-display-name": "Problem Description", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26817, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26817, | |
| "lib/desired-column-alias": "problem_description", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Problem Description", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 5.785714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "root_cause_seq", | |
| "lib/original-name": "root_cause_seq", | |
| "lib/breakout?": false, | |
| "name": "root_cause_seq", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "root_cause_seq", | |
| "lib/original-display-name": "Root Cause Seq", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26818, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26818, | |
| "lib/desired-column-alias": "root_cause_seq", | |
| "position": 7, | |
| "visibility_type": "normal", | |
| "display_name": "Root Cause Seq", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 12 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "root_cause", | |
| "lib/original-name": "root_cause", | |
| "lib/breakout?": false, | |
| "name": "root_cause", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "root_cause", | |
| "lib/original-display-name": "Root Cause", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26819, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26819, | |
| "lib/desired-column-alias": "root_cause", | |
| "position": 8, | |
| "visibility_type": "normal", | |
| "display_name": "Root Cause", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 14.857142857142858 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "countermeasure", | |
| "lib/original-name": "countermeasure", | |
| "lib/breakout?": false, | |
| "name": "countermeasure", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "countermeasure", | |
| "lib/original-display-name": "Countermeasure", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26820, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26820, | |
| "lib/desired-column-alias": "countermeasure", | |
| "position": 9, | |
| "visibility_type": "normal", | |
| "display_name": "Countermeasure", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 8.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "assignee", | |
| "lib/original-name": "assignee", | |
| "lib/breakout?": false, | |
| "name": "assignee", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "assignee", | |
| "lib/original-display-name": "Assignee", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26821, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26821, | |
| "lib/desired-column-alias": "assignee", | |
| "position": 10, | |
| "visibility_type": "normal", | |
| "display_name": "Assignee", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "expected_outcome", | |
| "lib/original-name": "expected_outcome", | |
| "lib/breakout?": false, | |
| "name": "expected_outcome", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "expected_outcome", | |
| "lib/original-display-name": "Expected Outcome", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26822, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26822, | |
| "lib/desired-column-alias": "expected_outcome", | |
| "position": 11, | |
| "visibility_type": "normal", | |
| "display_name": "Expected Outcome", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 8.285714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/CreationDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "target_completion_date", | |
| "lib/original-name": "target_completion_date", | |
| "lib/breakout?": false, | |
| "name": "target_completion_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "target_completion_date", | |
| "lib/original-display-name": "Target Completion Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY" | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26823, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26823, | |
| "lib/desired-column-alias": "target_completion_date", | |
| "position": 12, | |
| "visibility_type": "normal", | |
| "display_name": "Target Completion Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": "2025-10-31", | |
| "latest": "2025-12-31" | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "date", | |
| "semantic_type": "type/UpdatedDate", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "updated_completion_date", | |
| "lib/original-name": "updated_completion_date", | |
| "lib/breakout?": false, | |
| "name": "updated_completion_date", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "updated_completion_date", | |
| "lib/original-display-name": "Updated Completion Date", | |
| "settings": { | |
| "date_style": "M/D/YYYY", | |
| "closure_uid_754409280": 1075 | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26824, | |
| null | |
| ], | |
| "effective_type": "type/Date", | |
| "active": true, | |
| "id": 26824, | |
| "lib/desired-column-alias": "updated_completion_date", | |
| "position": 13, | |
| "visibility_type": "normal", | |
| "display_name": "Updated Completion Date", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 1 | |
| }, | |
| "type": { | |
| "type/DateTime": { | |
| "earliest": null, | |
| "latest": null | |
| } | |
| } | |
| }, | |
| "base_type": "type/Date" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "verify", | |
| "lib/original-name": "verify", | |
| "lib/breakout?": false, | |
| "name": "verify", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "verify", | |
| "lib/original-display-name": "Verify", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26825, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26825, | |
| "lib/desired-column-alias": "verify", | |
| "position": 14, | |
| "visibility_type": "normal", | |
| "display_name": "Verify", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0.9285714285714286 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0.9285714285714286 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "status", | |
| "lib/original-name": "status", | |
| "lib/breakout?": false, | |
| "name": "status", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "status", | |
| "lib/original-display-name": "Status", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26826, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26826, | |
| "lib/desired-column-alias": "status", | |
| "position": 15, | |
| "visibility_type": "normal", | |
| "display_name": "Status", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0.8571428571428571 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 0.6428571428571429 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_year", | |
| "lib/original-name": "pareto_year", | |
| "lib/breakout?": false, | |
| "name": "pareto_year", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_year", | |
| "lib/original-display-name": "Pareto Year", | |
| "settings": { | |
| "number_separators": "." | |
| }, | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26827, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26827, | |
| "lib/desired-column-alias": "pareto_year", | |
| "position": 16, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_month", | |
| "lib/original-name": "pareto_month", | |
| "lib/breakout?": false, | |
| "name": "pareto_month", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_month", | |
| "lib/original-display-name": "Pareto Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26828, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26828, | |
| "lib/desired-column-alias": "pareto_month", | |
| "position": 17, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "numeric", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "pareto_amount", | |
| "lib/original-name": "pareto_amount", | |
| "lib/breakout?": false, | |
| "name": "pareto_amount", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "pareto_amount", | |
| "lib/original-display-name": "Pareto Amount", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26829, | |
| null | |
| ], | |
| "effective_type": "type/Decimal", | |
| "active": true, | |
| "id": 26829, | |
| "lib/desired-column-alias": "pareto_amount", | |
| "position": 18, | |
| "visibility_type": "normal", | |
| "display_name": "Pareto Amount", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 14, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 687.75, | |
| "q1": 5772.5, | |
| "q3": 23095, | |
| "max": 101179.17, | |
| "sd": 30314.958093734684, | |
| "avg": 23419.851428571426 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Decimal" | |
| }, | |
| { | |
| "database_type": "int8", | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "subkpi_rank", | |
| "lib/original-name": "subkpi_rank", | |
| "lib/breakout?": false, | |
| "name": "subkpi_rank", | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "subkpi_rank", | |
| "lib/original-display-name": "Subkpi Rank", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26830, | |
| null | |
| ], | |
| "effective_type": "type/BigInteger", | |
| "active": true, | |
| "id": 26830, | |
| "lib/desired-column-alias": "subkpi_rank", | |
| "position": 19, | |
| "visibility_type": "normal", | |
| "display_name": "Subkpi Rank", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 7, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 2.25, | |
| "q3": 5.75, | |
| "max": 7, | |
| "sd": 2.0754980866510833, | |
| "avg": 4 | |
| } | |
| } | |
| }, | |
| "base_type": "type/BigInteger" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Flanders - Operating Expense - PDCA - Level1 - Ranked By Pareto", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T18:37:52.661484Z", | |
| "type": "model", | |
| "query_average_duration": 984, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T18:28:22.71767Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "lib/type": "mbql.stage/mbql", | |
| "source-table": 758 | |
| } | |
| ] | |
| }, | |
| "id": 241, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "table", | |
| "archived_directly": false, | |
| "entity_id": "DQvuttN_ZnDLAIVwhHNFt", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "table.pivot_column": "kpi", | |
| "table.cell_column": "overall_seq_no" | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-06T19:07:37.097029Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-12T17:08:46.672771Z", | |
| "col": 0, | |
| "id": 215, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 241, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "pareto_year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "parameter_id": "f9a5b8f4", | |
| "card_id": 241, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "location", | |
| { | |
| "base-type": "type/Text" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 241, | |
| "entity_id": "MSQrzhY_YLjWsnr2joHOB", | |
| "visualization_settings": { | |
| "table.pivot_column": "kpi", | |
| "table.cell_column": "overall_seq_no", | |
| "table.columns": [ | |
| { | |
| "name": "overall_seq_no", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "idea_no", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "location", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "kpi", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "sub_kpi", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "open_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "problem_description", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "root_cause_seq", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "root_cause", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "countermeasure", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "assignee", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "expected_outcome", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "target_completion_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "updated_completion_date", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "verify", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "pareto_year", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "status", | |
| "enabled": true | |
| }, | |
| { | |
| "name": "pareto_month", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "pareto_amount", | |
| "enabled": false | |
| }, | |
| { | |
| "name": "subkpi_rank", | |
| "enabled": false | |
| } | |
| ], | |
| "card.title": "", | |
| "table.column_widths": [ | |
| 60, | |
| 129, | |
| null, | |
| 170, | |
| 177, | |
| 197, | |
| null, | |
| 188, | |
| 157, | |
| 146 | |
| ], | |
| "table.column_formatting": [], | |
| "column_settings": { | |
| "[\"name\",\"problem_description\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"root_cause\"]": { | |
| "column_title": "Potential Root Cause", | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"countermeasure\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"expected_outcome\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"verify\"]": { | |
| "text_wrapping": true | |
| }, | |
| "[\"name\",\"status\"]": { | |
| "text_wrapping": true | |
| } | |
| } | |
| }, | |
| "size_y": 8, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T18:30:20.315875Z", | |
| "row": 7 | |
| }, | |
| { | |
| "size_x": 9, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "query_average_duration": null, | |
| "download_perms": "none" | |
| }, | |
| "updated_at": "2026-02-11T20:03:13.983963Z", | |
| "col": 0, | |
| "id": 219, | |
| "parameter_mappings": [], | |
| "card_id": null, | |
| "entity_id": "1ZYThfMIb4NJ0MYszS2KE", | |
| "visualization_settings": { | |
| "virtual_card": { | |
| "name": null, | |
| "display": "text", | |
| "visualization_settings": {}, | |
| "archived": false | |
| }, | |
| "text": "PLAN", | |
| "text.align_horizontal": "center" | |
| }, | |
| "size_y": 1, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T19:50:30.427273Z", | |
| "row": 6 | |
| }, | |
| { | |
| "size_x": 1, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "query_average_duration": null, | |
| "download_perms": "none" | |
| }, | |
| "updated_at": "2026-02-12T14:35:58.261223Z", | |
| "col": 21, | |
| "id": 220, | |
| "parameter_mappings": [], | |
| "card_id": null, | |
| "entity_id": "cjne8AJKnUswKbSrx3xew", | |
| "visualization_settings": { | |
| "virtual_card": { | |
| "name": null, | |
| "display": "text", | |
| "visualization_settings": {}, | |
| "archived": false | |
| }, | |
| "text": "CHECK", | |
| "text.align_horizontal": "center" | |
| }, | |
| "size_y": 1, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T19:50:30.427273Z", | |
| "row": 6 | |
| }, | |
| { | |
| "size_x": 2, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "query_average_duration": null, | |
| "download_perms": "none" | |
| }, | |
| "updated_at": "2026-02-12T14:35:58.261223Z", | |
| "col": 22, | |
| "id": 221, | |
| "parameter_mappings": [], | |
| "card_id": null, | |
| "entity_id": "tp_lHewJSZSdeJEQ6rB94", | |
| "visualization_settings": { | |
| "virtual_card": { | |
| "name": null, | |
| "display": "text", | |
| "visualization_settings": {}, | |
| "archived": false | |
| }, | |
| "text": "ACT", | |
| "text.align_horizontal": "center" | |
| }, | |
| "size_y": 1, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T19:50:30.427273Z", | |
| "row": 6 | |
| }, | |
| { | |
| "size_x": 12, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "query_average_duration": null, | |
| "download_perms": "none" | |
| }, | |
| "updated_at": "2026-02-12T14:35:58.261223Z", | |
| "col": 9, | |
| "id": 218, | |
| "parameter_mappings": [], | |
| "card_id": null, | |
| "entity_id": "Pxk8dgAryR8V3iFkMD4lX", | |
| "visualization_settings": { | |
| "virtual_card": { | |
| "name": null, | |
| "display": "text", | |
| "visualization_settings": {}, | |
| "archived": false | |
| }, | |
| "text": "DO", | |
| "text.align_horizontal": "center" | |
| }, | |
| "size_y": 1, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-11T19:50:30.427273Z", | |
| "row": 6 | |
| }, | |
| { | |
| "size_x": 12, | |
| "dashboard_tab_id": 22, | |
| "series": [], | |
| "inline_parameters": [], | |
| "action_id": null, | |
| "collection_authority_level": null, | |
| "card": { | |
| "cache_invalidated_at": null, | |
| "description": null, | |
| "archived": false, | |
| "view_count": 26, | |
| "collection_position": null, | |
| "source_card_id": 236, | |
| "table_id": 718, | |
| "result_metadata": [ | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Location", | |
| "lib/original-name": "Location", | |
| "lib/breakout?": false, | |
| "name": "Location", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Location", | |
| "lib/original-display-name": "Location", | |
| "lib/model-display-name": "Location", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26757, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26757, | |
| "lib/desired-column-alias": "Location", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Location", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 7 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Year", | |
| "lib/original-name": "Year", | |
| "lib/breakout?": false, | |
| "name": "Year", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Year", | |
| "lib/original-display-name": "Year", | |
| "settings": { | |
| "number_separators": "." | |
| }, | |
| "lib/model-display-name": "Year", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26758, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26758, | |
| "lib/desired-column-alias": "Year", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Year", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 1, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 2025, | |
| "q1": 2025, | |
| "q3": 2025, | |
| "max": 2025, | |
| "sd": 0, | |
| "avg": 2025 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Month", | |
| "lib/original-name": "Month", | |
| "lib/breakout?": false, | |
| "name": "Month", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Month", | |
| "lib/original-display-name": "Month", | |
| "lib/model-display-name": "Month", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26759, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26759, | |
| "lib/desired-column-alias": "Month", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Month", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 3 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "int4", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "month_num", | |
| "lib/original-name": "month_num", | |
| "lib/breakout?": false, | |
| "name": "month_num", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "month_num", | |
| "lib/original-display-name": "Month Num", | |
| "lib/model-display-name": "Month Num", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26760, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 26760, | |
| "lib/desired-column-alias": "month_num", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Month Num", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 12, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 1, | |
| "q1": 3.5, | |
| "q3": 9.5, | |
| "max": 12, | |
| "sd": 3.4762777567757044, | |
| "avg": 6.5 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Category", | |
| "lib/original-name": "Category", | |
| "lib/breakout?": false, | |
| "name": "Category", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Category", | |
| "lib/original-display-name": "Category", | |
| "lib/model-display-name": "Category", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26761, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26761, | |
| "lib/desired-column-alias": "Category", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Category", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 3, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 17 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "text", | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Measure", | |
| "lib/original-name": "Measure", | |
| "lib/breakout?": false, | |
| "name": "Measure", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Measure", | |
| "lib/original-display-name": "Measure", | |
| "lib/model-display-name": "Measure", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26762, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 26762, | |
| "lib/desired-column-alias": "Measure", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Measure", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 2, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Text": { | |
| "percent-json": 0, | |
| "percent-url": 0, | |
| "percent-email": 0, | |
| "percent-state": 0, | |
| "average-length": 5.333333333333333 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "numeric", | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "qp/implicit-field?": true, | |
| "lib/deduplicated-name": "Value", | |
| "lib/original-name": "Value", | |
| "lib/breakout?": false, | |
| "name": "Value", | |
| "lib/card-id": 236, | |
| "lib/source": "source/previous-stage", | |
| "lib/source-column-alias": "Value", | |
| "lib/original-display-name": "Value", | |
| "lib/model-display-name": "Value", | |
| "source": "fields", | |
| "field_ref": [ | |
| "field", | |
| 26763, | |
| null | |
| ], | |
| "effective_type": "type/Decimal", | |
| "active": true, | |
| "id": 26763, | |
| "lib/desired-column-alias": "Value", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Value", | |
| "fingerprint": { | |
| "global": { | |
| "distinct-count": 35, | |
| "nil%": 0 | |
| }, | |
| "type": { | |
| "type/Number": { | |
| "min": 0, | |
| "q1": 24767.271450907512, | |
| "q3": 154409.5, | |
| "max": 245675.55, | |
| "sd": 77987.6991741083, | |
| "avg": 101883.4786111111 | |
| } | |
| } | |
| }, | |
| "base_type": "type/Decimal" | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "card_schema": 23, | |
| "database_id": 9, | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "query_type": "query", | |
| "download_perms": "full", | |
| "name": "Operating Expenses (1)", | |
| "document_id": null, | |
| "last_used_at": "2026-02-16T18:37:52.661484Z", | |
| "type": "question", | |
| "query_average_duration": 207, | |
| "creator_id": 12, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T18:40:56.460311Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "dataset_query": { | |
| "lib/type": "mbql/query", | |
| "database": 9, | |
| "stages": [ | |
| { | |
| "source-card": 236, | |
| "lib/type": "mbql.stage/mbql", | |
| "order-by": [ | |
| [ | |
| "asc", | |
| { | |
| "lib/uuid": "aa8befc9-b1e7-4031-a1d3-0d233ff86b72" | |
| }, | |
| [ | |
| "field", | |
| { | |
| "effective-type": "type/Integer", | |
| "lib/uuid": "7a8cf827-7a9e-4c3c-9d40-497a1d7562c0", | |
| "base-type": "type/Integer" | |
| }, | |
| "month_num" | |
| ] | |
| ] | |
| ] | |
| } | |
| ] | |
| }, | |
| "id": 247, | |
| "legacy_query": null, | |
| "parameter_mappings": [], | |
| "display": "combo", | |
| "archived_directly": false, | |
| "entity_id": "8GjaSvJTtKd_N6g3NlvDh", | |
| "collection_preview": true, | |
| "visualization_settings": { | |
| "graph.dimensions": [ | |
| "Month", | |
| "Category" | |
| ], | |
| "graph.series_order_dimension": null, | |
| "graph.series_order": null, | |
| "series_settings": { | |
| "current_year_total": { | |
| "title": "Current Year", | |
| "display": "bar" | |
| }, | |
| "monthly_budget": { | |
| "title": "Budget", | |
| "display": "line", | |
| "line.interpolate": "cardinal" | |
| }, | |
| "previous_year_total": { | |
| "display": "line", | |
| "title": "Previous Year", | |
| "line.interpolate": "linear" | |
| } | |
| }, | |
| "graph.x_axis.scale": "ordinal", | |
| "graph.metrics": [ | |
| "Value" | |
| ] | |
| }, | |
| "metabase_version": "v1.58.5.1 (f7fafc1)", | |
| "parameters": [], | |
| "dashboard_id": null, | |
| "created_at": "2026-02-11T18:40:56.435289Z", | |
| "public_uuid": null | |
| }, | |
| "updated_at": "2026-02-12T17:08:46.672771Z", | |
| "col": 0, | |
| "id": 222, | |
| "parameter_mappings": [ | |
| { | |
| "parameter_id": "1736832f", | |
| "card_id": 247, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "Year", | |
| { | |
| "base-type": "type/Integer" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "parameter_id": "f9a5b8f4", | |
| "card_id": 247, | |
| "target": [ | |
| "dimension", | |
| [ | |
| "field", | |
| "Location", | |
| { | |
| "base-type": "type/Text" | |
| } | |
| ], | |
| { | |
| "stage-number": 0 | |
| } | |
| ] | |
| } | |
| ], | |
| "card_id": 247, | |
| "entity_id": "1E3h45HdMbWKMU-UTav_H", | |
| "visualization_settings": { | |
| "visualization": { | |
| "display": "combo", | |
| "columnValuesMapping": { | |
| "COLUMN_1": [ | |
| { | |
| "sourceId": "card:247", | |
| "originalName": "Month", | |
| "name": "COLUMN_1" | |
| } | |
| ], | |
| "COLUMN_2": [ | |
| { | |
| "sourceId": "card:247", | |
| "originalName": "Category", | |
| "name": "COLUMN_2" | |
| } | |
| ], | |
| "COLUMN_3": [ | |
| { | |
| "sourceId": "card:247", | |
| "originalName": "Value", | |
| "name": "COLUMN_3" | |
| } | |
| ] | |
| }, | |
| "settings": { | |
| "graph.dimensions": [ | |
| "COLUMN_1", | |
| "COLUMN_2" | |
| ], | |
| "graph.series_order_dimension": null, | |
| "graph.series_order": null, | |
| "series_settings": { | |
| "current_year_total": { | |
| "title": "Current Year", | |
| "display": "bar" | |
| }, | |
| "monthly_budget": { | |
| "title": "Budget", | |
| "display": "line", | |
| "line.interpolate": "cardinal" | |
| }, | |
| "previous_year_total": { | |
| "display": "line", | |
| "title": "Previous Year", | |
| "line.interpolate": "linear" | |
| } | |
| }, | |
| "graph.x_axis.scale": "ordinal", | |
| "graph.metrics": [ | |
| "COLUMN_3" | |
| ] | |
| } | |
| } | |
| }, | |
| "size_y": 6, | |
| "dashboard_id": 21, | |
| "created_at": "2026-02-12T14:45:45.373505Z", | |
| "row": 0 | |
| } | |
| ], | |
| "embedding_type": null, | |
| "dependency_analysis_version": 3, | |
| "initially_published_at": null, | |
| "can_write": true, | |
| "tabs": [ | |
| { | |
| "id": 22, | |
| "dashboard_id": 21, | |
| "name": "Operating Expense", | |
| "position": 0, | |
| "entity_id": "DdxC5jd2YVEdkG4AuOb6O", | |
| "created_at": "2026-02-11T18:30:20.315875Z", | |
| "updated_at": "2026-02-11T19:13:49.570022Z" | |
| }, | |
| { | |
| "id": 21, | |
| "dashboard_id": 21, | |
| "name": "Service", | |
| "position": 1, | |
| "entity_id": "xOzb-i-FVY0OJb2TyUm9E", | |
| "created_at": "2026-02-11T18:30:20.315875Z", | |
| "updated_at": "2026-02-11T19:13:49.570022Z" | |
| } | |
| ], | |
| "enable_embedding": false, | |
| "collection_id": 20, | |
| "show_in_getting_started": false, | |
| "name": "Flanders PDCA", | |
| "is_remote_synced": false, | |
| "width": "full", | |
| "caveats": null, | |
| "collection_authority_level": null, | |
| "creator_id": 12, | |
| "can_restore": false, | |
| "moderation_reviews": [], | |
| "updated_at": "2026-02-11T19:55:29.932945Z", | |
| "made_public_by_id": null, | |
| "embedding_params": null, | |
| "cache_ttl": null, | |
| "last_used_param_values": { | |
| "f9a5b8f4": [ | |
| "Evansville" | |
| ] | |
| }, | |
| "id": 21, | |
| "last_viewed_at": "2026-02-16T18:37:52.576653Z", | |
| "position": null, | |
| "archived_directly": false, | |
| "entity_id": "lxbm2oDuaMP4qKxOQlzP7", | |
| "param_fields": { | |
| "f9a5b8f4": [ | |
| { | |
| "semantic_type": "type/Category", | |
| "table_id": 758, | |
| "name": "location", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26813, | |
| "target": null, | |
| "display_name": "Location", | |
| "name_field": null, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "semantic_type": "type/Category", | |
| "table_id": 749, | |
| "name": "Location", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26764, | |
| "target": null, | |
| "display_name": "Location", | |
| "name_field": null, | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "semantic_type": "type/Category", | |
| "table_id": 718, | |
| "name": "Location", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26757, | |
| "target": null, | |
| "display_name": "Location", | |
| "name_field": null, | |
| "base_type": "type/Text" | |
| } | |
| ], | |
| "1736832f": [ | |
| { | |
| "semantic_type": null, | |
| "table_id": 758, | |
| "name": "pareto_year", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26827, | |
| "target": null, | |
| "display_name": "Pareto Year", | |
| "name_field": null, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": null, | |
| "table_id": 763, | |
| "name": "year", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26875, | |
| "target": null, | |
| "display_name": "Year", | |
| "name_field": null, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": null, | |
| "table_id": 749, | |
| "name": "Year", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26765, | |
| "target": null, | |
| "display_name": "Year", | |
| "name_field": null, | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": null, | |
| "table_id": 718, | |
| "name": "Year", | |
| "has_field_values": "list", | |
| "fk_target_field_id": null, | |
| "dimensions": [], | |
| "id": 26758, | |
| "target": null, | |
| "display_name": "Year", | |
| "name_field": null, | |
| "base_type": "type/Integer" | |
| } | |
| ] | |
| }, | |
| "last-edit-info": { | |
| "id": 12, | |
| "email": "redacted", | |
| "first_name": "Admin", | |
| "last_name": "DevOps", | |
| "timestamp": "2026-02-12T17:08:46.744539Z" | |
| }, | |
| "collection": { | |
| "authority_level": null, | |
| "description": null, | |
| "archived": false, | |
| "slug": "centerrock", | |
| "archive_operation_id": null, | |
| "name": "CenterRock", | |
| "is_remote_synced": false, | |
| "personal_owner_id": null, | |
| "type": null, | |
| "is_sample": false, | |
| "effective_location": "/5/", | |
| "id": 20, | |
| "archived_directly": null, | |
| "entity_id": "gcgiPnfQxUCmqzWusba1T", | |
| "location": "/5/", | |
| "namespace": null, | |
| "is_personal": false, | |
| "created_at": "2025-10-06T16:33:48.661221Z" | |
| }, | |
| "parameters": [ | |
| { | |
| "name": "Year", | |
| "slug": "year", | |
| "id": "1736832f", | |
| "type": "number/=", | |
| "sectionId": "number" | |
| }, | |
| { | |
| "name": "Location", | |
| "slug": "location", | |
| "id": "f9a5b8f4", | |
| "type": "string/=", | |
| "sectionId": "string" | |
| } | |
| ], | |
| "auto_apply_filters": true, | |
| "created_at": "2026-02-06T16:07:07.589874Z", | |
| "public_uuid": null, | |
| "points_of_interest": null, | |
| "can_delete": false | |
| } | |
| </details> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment