The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
{:metabase_database
({:uploads_schema_name nil,
:description "Some example data for you to play around with.",
:uploads_table_prefix nil,
:cache_field_values_schedule "0 0 19 * * ? *",
:timezone "UTC",
:is_attached_dwh false,
:auto_run_queries true,
:metadata_sync_schedule "0 48 * * * ? *",
:name "Sample Database",
:settings nil,
:caveats
"You probably don't want to use this for your business-critical analyses, but hey, it's your world, we're just living in it.",
:creator_id 13371338,
:is_full_sync true,
:updated_at #t "2026-02-23T11:14:56.563647Z",
:cache_ttl nil,
:details "{}",
:is_sample true,
:id 1,
:is_on_demand false,
:engine "sqlite",
:initial_sync_status "complete",
:is_audit false,
:dbms_version "{}",
:uploads_enabled false,
:refingerprint nil,
:created_at #t "2026-02-23T11:14:53.782096Z",
:points_of_interest
"You can find all sorts of different joinable tables ranging from products to people to reviews here."}),
:report_dashboard
({:description "Overview of sample data and hypothetical sales",
:archived false,
:collection_position 2,
:initially_published_at nil,
:enable_embedding false,
:collection_id 2,
:show_in_getting_started false,
:name "E-commerce Insights",
:width "fixed",
:caveats nil,
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:id 1,
:last_viewed_at #t "2026-02-23T19:44:12.108553Z",
:position nil,
:archived_directly false,
:entity_id "xBLdW9FsgRuB2HGhWiBa_",
:parameters
"[{\"id\":\"81cd957\",\"name\":\"Date Range\",\"required\":false,\"sectionId\":\"date\",\"slug\":\"date_range\",\"type\":\"date/all-options\"},{\"id\":\"efd919c7\",\"name\":\"Date Grouping\",\"sectionId\":\"temporal-unit\",\"slug\":\"date_grouping\",\"type\":\"temporal-unit\"},{\"default\":[\"Doohickey\",\"Gizmo\",\"Gadget\",\"Widget\"],\"id\":\"9d9cddd4\",\"name\":\"Product Category\",\"required\":true,\"sectionId\":\"string\",\"slug\":\"product_category\",\"type\":\"string/=\"},{\"id\":\"1ebab259\",\"isMultiSelect\":false,\"name\":\"Vendor\",\"sectionId\":\"string\",\"slug\":\"vendor\",\"type\":\"string/=\"}]",
:auto_apply_filters true,
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil,
:points_of_interest nil}),
:data_permissions
({:id 1,
:group_id 1,
:perm_type "perms/view-data",
:db_id 1,
:schema_name nil,
:table_id nil,
:perm_value "unrestricted"}
{:id 2,
:group_id 1,
:perm_type "perms/create-queries",
:db_id 1,
:schema_name nil,
:table_id nil,
:perm_value "query-builder-and-native"}
{:id 3,
:group_id 1,
:perm_type "perms/download-results",
:db_id 1,
:schema_name nil,
:table_id nil,
:perm_value "one-million-rows"}
{:id 4,
:group_id 1,
:perm_type "perms/manage-table-metadata",
:db_id 1,
:schema_name nil,
:table_id nil,
:perm_value "no"}
{:id 5,
:group_id 1,
:perm_type "perms/manage-database",
:db_id 1,
:schema_name nil,
:table_id nil,
:perm_value "no"}),
:metabase_table
({:description "Information on the user accounts registered with Sample Company.",
:entity_type "entity/UserTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "PEOPLE",
:caveats "Note that employees and customer support staff will have accounts.",
:updated_at #t "2026-02-23T11:14:56.716905Z",
:active true,
:id 1,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "People",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? You tell us!"}
{:description "Confirmed Sample Company orders for a product, from a user.",
:entity_type "entity/TransactionTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "ORDERS",
:caveats
"You can join this on the Products and Orders table using the ID fields. Discount is left null if not applicable.",
:updated_at #t "2026-02-23T11:14:56.739345Z",
:active true,
:id 2,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Orders",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? You tell us!"}
{:description "Includes a catalog of all the products ever sold by the famed Sample Company.",
:entity_type "entity/ProductTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "PRODUCTS",
:caveats "The rating column is an integer from 1-5 where 1 is dreadful and 5 is the best thing ever.",
:updated_at #t "2026-02-23T11:14:56.698226Z",
:active true,
:id 3,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Products",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? You tell us!"}
{:description "Reviews that Sample Company customers have left on our products.",
:entity_type "entity/GenericTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "REVIEWS",
:caveats
"These reviews aren't tied to orders so it is possible people have reviewed products they did not purchase from us.",
:updated_at #t "2026-02-23T11:14:56.749952Z",
:active true,
:id 4,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Reviews",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? You tell us!"}
{:description
"With each order of pies sent out, Piespace includes a place for customers to submit feedback and review their order.",
:entity_type "entity/GenericTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "FEEDBACK",
:caveats
"Not every account feels inclined to submit feedback. That’s cool. There’s still quite a few responses here.",
:updated_at #t "2026-02-23T11:14:56.757041Z",
:active true,
:id 5,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Feedback",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? We’ll let you be the judge of that."}
{:description
"Information on customer accounts registered with Piespace. Each account represents a new organization signing up for on-demand pies.",
:entity_type "entity/UserTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "ACCOUNTS",
:caveats
"Piespace’s business operates with a two week trial period. If you see that “Canceled At” is null then that account is still happily paying for their pies.",
:updated_at #t "2026-02-23T11:14:56.782591Z",
:active true,
:id 6,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Accounts",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? We’ll let you be the judge of that."}
{:description
"Piespace does some anonymous analytics tracking on how users interact with their platform. They’ve only had time to implement a few events, but you know how it is. Pies come first.",
:entity_type "entity/EventTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "ANALYTIC_EVENTS",
:caveats
"Piespace has cracked time travel, so keep in mind that some events may have already happened in the future.",
:updated_at #t "2026-02-23T11:14:56.770963Z",
:active true,
:id 7,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Analytic Events",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? We’ll let you be the judge of that."}
{:description
"Confirmed payments from Piespace’s customers. Most accounts pay for their pie subscription on a monthly basis.",
:entity_type "entity/GenericTable",
:schema nil,
:database_require_filter nil,
:show_in_getting_started false,
:name "INVOICES",
:caveats
"You can group by “Account ID” to see all the payments from an account and unveil information like total amount paid to date.",
:updated_at #t "2026-02-23T11:14:56.731823Z",
:active true,
:id 8,
:db_id 1,
:visibility_type nil,
:field_order "database",
:is_upload false,
:initial_sync_status "complete",
:display_name "Invoices",
:created_at #t "2026-02-23T11:14:53.782096Z",
:estimated_row_count nil,
:points_of_interest "Is it? We’ll let you be the judge of that."}),
:report_dashboardcard
({:size_x 12,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 1,
:parameter_mappings "[]",
:card_id 21,
:entity_id "OO4kGtX3HOooGeROYUZJe",
:visualization_settings
"{\"click_behavior\":{\"parameterMapping\":{\"9d9cddd4\":{\"id\":\"9d9cddd4\",\"source\":{\"id\":\"CATEGORY\",\"name\":\"Product → Category\",\"type\":\"column\"},\"target\":{\"id\":\"9d9cddd4\",\"type\":\"parameter\"}}},\"type\":\"crossfilter\"},\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 10}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 2,
:parameter_mappings
"[{\"card_id\":24,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":24,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]},{\"card_id\":24,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":24,\"parameter_id\":\"efd919c7\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]}]",
:card_id 24,
:entity_id "AmK0nHFFIARIPCWx7RHj8",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 23}
{:size_x 10,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 3,
:parameter_mappings "[]",
:card_id 22,
:entity_id "YIP_KpvNnw0g7igNvwMVp",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 34}
{:size_x 12,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:51.010848Z",
:col 12,
:id 4,
:parameter_mappings
"[{\"card_id\":2,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 2,
:entity_id "gi60ETDzDM8MxIUN9Nt-7",
:visualization_settings "{\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 10}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 5,
:parameter_mappings "[]",
:card_id 18,
:entity_id "4bnIg0l06MqSikGg2jPM1",
:visualization_settings "{\"column_settings\":null}",
:size_y 6,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 26}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 6,
:parameter_mappings
"[{\"card_id\":12,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":12,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]},{\"card_id\":12,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":12,\"parameter_id\":\"efd919c7\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]}]",
:card_id 12,
:entity_id "mM0yHMzeaWUi0uJkT1puj",
:visualization_settings "{\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 6}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 7,
:parameter_mappings "[]",
:card_id nil,
:entity_id "8_qdLmnHn3tGOaDdbLTwn",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Overall Business Health\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 0}
{:size_x 8,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 8,
:parameter_mappings
"[{\"card_id\":15,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":15,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]},{\"card_id\":15,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":15,\"parameter_id\":\"efd919c7\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]}]",
:card_id 15,
:entity_id "_VxmRsylZKkpe0H-lGwyT",
:visualization_settings "{\"column_settings\":null}",
:size_y 4,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 2}
{:size_x 9,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 8,
:id 9,
:parameter_mappings
"[{\"card_id\":17,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":17,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]},{\"card_id\":17,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 17,
:entity_id "vPyErYUpYMjucZa7z4smS",
:visualization_settings "{\"column_settings\":null}",
:size_y 4,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 2}
{:size_x 12,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 12,
:id 10,
:parameter_mappings
"[{\"card_id\":13,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":13,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\",\"original-temporal-unit\":\"quarter\"}],{\"stage-number\":0}]},{\"card_id\":13,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":13,\"parameter_id\":\"efd919c7\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\",\"original-temporal-unit\":\"quarter\"}],{\"stage-number\":0}]}]",
:card_id 13,
:entity_id "3MGVK2PTcGxJwDXlDqjSE",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 16}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 11,
:parameter_mappings "[]",
:card_id nil,
:entity_id "zsygIGYHdnaVsoFLgitCe",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Deeper Dive\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 14}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 12,
:parameter_mappings
"[{\"card_id\":10,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":10,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]},{\"card_id\":10,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":10,\"parameter_id\":\"efd919c7\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]}]",
:card_id 10,
:entity_id "fRjV39ywXfG8mj6NFsXH4",
:visualization_settings "{\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 30}
{:size_x 12,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 13,
:parameter_mappings
"[{\"card_id\":20,\"parameter_id\":\"1ebab259\",\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"card_id\":20,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]},{\"card_id\":20,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 20,
:entity_id "-zrxIkj-jscf4OwBR435T",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 16}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 14,
:parameter_mappings "[]",
:card_id nil,
:entity_id "wYtzbytCKhibM8Zg9s4VP",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Top Performing Products\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 0}
{:size_x 12,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 15,
:parameter_mappings "[]",
:card_id 7,
:entity_id "wuIanq5bdBiexA3yhyO0w",
:visualization_settings "{\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 2}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 16,
:parameter_mappings "[]",
:card_id nil,
:entity_id "WD8BNj-NyWXaWuFghZNDU",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Business KPIs _look strong_ based on the consistent MoM revenue growth following the growth in the number of orders\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 1}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 17,
:parameter_mappings "[{\"parameter_id\":\"9d9cddd4\",\"target\":[\"text-tag\",\"product_category\"]}]",
:card_id nil,
:entity_id "NZSFQPtNkT7fLZeeW9Oo0",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Find below a breakdown of products and their performance, filtered now for {{product_category}}\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 1}
{:size_x 24,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:24:27.534360Z",
:col 0,
:id 18,
:parameter_mappings "[]",
:card_id nil,
:entity_id "f-Hf9bL9_oArQCg-kLSdY",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Widget and Gizmo are our leading products, generating the most revenue and orders\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 15}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 19,
:parameter_mappings
"[{\"card_id\":8,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 8,
:entity_id "-IoAlBOQzsTLapLzSFQoE",
:visualization_settings "{\"column_settings\":null}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 18}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 20,
:parameter_mappings "[]",
:card_id nil,
:entity_id "YyZMLS7IGhXda6vmEfJ4I",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Customer Satisfaction\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 32}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 21,
:parameter_mappings "[]",
:card_id nil,
:entity_id "MS4_Du2Fd3qkjpaRZFOqm",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Super important customer ratings for our products\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 33}
{:size_x 14,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 10,
:id 22,
:parameter_mappings
"[{\"card_id\":3,\"parameter_id\":\"9d9cddd4\",\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 3,
:entity_id "WNCZfFyxCnhkAttN_rsIy",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 34}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 23,
:parameter_mappings "[]",
:card_id nil,
:entity_id "K2tgkIzRB0_cSP8jrVZ6p",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Website Analysis\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 0}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 24,
:parameter_mappings "[]",
:card_id nil,
:entity_id "DTpP8-129mKPp9oxsq_4R",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Take a look into our customer funnel and website performance\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 1}
{:size_x 24,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 0,
:id 25,
:parameter_mappings "[]",
:card_id 5,
:entity_id "19JbScZRjz5mSQ7chtjuY",
:visualization_settings "{\"column_settings\":null}",
:size_y 10,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 41}
{:size_x 14,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 26,
:parameter_mappings "[]",
:card_id 6,
:entity_id "fx-Zfyq1gaIcq2axhIRls",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 9}
{:size_x 10,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 14,
:id 27,
:parameter_mappings
"[{\"card_id\":16,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",\"TIMESTAMP\",{\"base-type\":\"type/DateTime\",\"inherited-temporal-unit\":\"month\"}],{\"stage-number\":1}]}]",
:card_id 16,
:entity_id "wZV8zAS2XAMH_ub1DG58A",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 9}
{:size_x 10,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 14,
:id 28,
:parameter_mappings
"[{\"card_id\":23,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",31,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":0}]}]",
:card_id 23,
:entity_id "R6UJhgRJd678v2nvAioH_",
:visualization_settings "{\"column_settings\":null}",
:size_y 6,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 16}
{:size_x 10,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T12:42:04.509975Z",
:col 14,
:id 29,
:parameter_mappings "[]",
:card_id nil,
:entity_id "ZuOmZNE78gKe16jyqSRX4",
:visualization_settings
"{\"link\":{\"entity\":{\"model\":\"card\",\"id\":25,\"name\":\"All subscriptions in table view\",\"description\":\"More complete look at all recent subscriptions\",\"collection_id\":2,\"display\":\"table\",\"db_id\":null}},\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"link\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 22}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 30,
:parameter_mappings "[]",
:card_id 11,
:entity_id "x6_b5ifhvPkZKw3ZgFcPy",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 2}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 31,
:parameter_mappings "[]",
:card_id nil,
:entity_id "sCNcFfp3EeaizKg0VtW4e",
:visualization_settings
"{\"column_settings\":null,\"iframe\":\"https://www.youtube.com/watch?v=dnT2Xj52mnk\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"iframe\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 10,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 25}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 32,
:parameter_mappings "[]",
:card_id nil,
:entity_id "OlrrrzZShIqvGE6RAjqbr",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Find more guides and tutorials on Metabase, analytics, data modeling, and more at [Metabase Learn](https://www.metabase.com/learn)\\n\\n\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"text\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 24}
{:size_x 24,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 33,
:parameter_mappings "[]",
:card_id nil,
:entity_id "Rq9NMjA_Y28ZDB-nwO8vI",
:visualization_settings
"{\"column_settings\":null,\"dashcard.background\":false,\"text\":\"Appendix\",\"virtual_card\":{\"archived\":false,\"dataset_query\":{},\"display\":\"heading\",\"name\":null,\"visualization_settings\":{}}}",
:size_y 1,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 23}
{:size_x 14,
:dashboard_tab_id 3,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:col 0,
:id 34,
:parameter_mappings
"[{\"card_id\":14,\"parameter_id\":\"81cd957\",\"target\":[\"dimension\",[\"field\",31,{\"base-type\":\"type/DateTime\"}],{\"stage-number\":1}]}]",
:card_id 14,
:entity_id "VkOq2o1cbIeE2MYeP4mfx",
:visualization_settings "{\"column_settings\":null}",
:size_y 7,
:dashboard_id 1,
:created_at #t "2026-02-23T11:14:53.782096Z",
:row 16}
{:size_x 12,
:dashboard_tab_id 2,
:updated_at #t "2026-02-23T12:42:51.010848Z",
:col 12,
:id 35,
:parameter_mappings
"[{\"parameter_id\":\"9d9cddd4\",\"card_id\":38,\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 38,
:entity_id "yCSg52K0YhSJJJLtx9f71",
:visualization_settings "{}",
:size_y 8,
:dashboard_id 1,
:created_at #t "2026-02-23T12:42:04.509975Z",
:row 2}
{:size_x 7,
:dashboard_tab_id 1,
:updated_at #t "2026-02-23T19:42:14.192227Z",
:col 17,
:id 37,
:parameter_mappings
"[{\"parameter_id\":\"81cd957\",\"card_id\":39,\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]},{\"parameter_id\":\"efd919c7\",\"card_id\":39,\"target\":[\"dimension\",[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],{\"stage-number\":0}]},{\"parameter_id\":\"9d9cddd4\",\"card_id\":39,\"target\":[\"dimension\",[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]},{\"parameter_id\":\"1ebab259\",\"card_id\":39,\"target\":[\"dimension\",[\"field\",34,{\"base-type\":\"type/Text\",\"source-field\":14}],{\"stage-number\":0}]}]",
:card_id 39,
:entity_id "2zzut2MukDsWpA_hVVghb",
:visualization_settings "{}",
:size_y 4,
:dashboard_id 1,
:created_at #t "2026-02-23T19:09:31.770116Z",
:row 2}),
:dimension
({:id 1,
:field_id 11,
:name "User ID",
:type "external",
:human_readable_field_id 48,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "iKRAu625kqCMgV-JyIcvs"}
{:id 2,
:field_id 14,
:name "Product ID",
:type "external",
:human_readable_field_id 17,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "aqoaaV9goPLaQujZaH95n"}
{:id 3,
:field_id 45,
:name "Account ID",
:type "external",
:human_readable_field_id 62,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "AFLhJxw0xV5v07piEOxaz"}
{:id 4,
:field_id 25,
:name "Account ID",
:type "external",
:human_readable_field_id 62,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "zhNaiuhdjVJpsjpa6uhYW"}
{:id 5,
:field_id 66,
:name "Account ID",
:type "external",
:human_readable_field_id 62,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "MfYtxAeN1DncrCv6pPxKl"}
{:id 6,
:field_id 65,
:name "Product ID",
:type "external",
:human_readable_field_id 17,
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z",
:entity_id "5AdkLQx_zwtvKv4bm-a1t"}),
:dashboard_tab
({:id 1,
:dashboard_id 1,
:name "Overview",
:position 0,
:entity_id "UaPZl7PULaGoAGquao9XS",
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z"}
{:id 2,
:dashboard_id 1,
:name "Portfolio Performance",
:position 1,
:entity_id "N-o1tJ9swdO4YJycqMA8P",
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z"}
{:id 3,
:dashboard_id 1,
:name "Website Analysis",
:position 2,
:entity_id "dJjVk7QtJaNp6panPlnH5",
:created_at #t "2026-02-23T11:14:53.782096Z",
:updated_at #t "2026-02-23T11:14:53.782096Z"}),
:metabase_field
({:description "The state or province of the account’s billing address",
:database_type "CHARACTER",
:semantic_type "type/State",
:table_id 1,
:coercion_strategy nil,
:name "STATE",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.891063Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 1,
:position 7,
:visibility_type "normal",
:display_name "State",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "Number of products bought.",
:database_type "INTEGER",
:semantic_type "type/Quantity",
:table_id 2,
:coercion_strategy nil,
:name "QUANTITY",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.921812Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 2,
:position 8,
:visibility_type "normal",
:display_name "Quantity",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description "Discount amount.",
:database_type "DOUBLE PRECISION",
:semantic_type "type/Discount",
:table_id 2,
:coercion_strategy nil,
:name "DISCOUNT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.910615Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 3,
:position 6,
:visibility_type "normal",
:display_name "Discount",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "A unique identifier given to each user.",
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 1,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.886234Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 4,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description "The total billed amount.",
:database_type "DOUBLE PRECISION",
:semantic_type nil,
:table_id 2,
:coercion_strategy nil,
:name "TOTAL",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.931798Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 5,
:position 5,
:visibility_type "normal",
:display_name "Total",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description
"This is the amount of local and federal taxes that are collected on the purchase. Note that other governmental fees on some products are not included here, but instead are accounted for in the subtotal.",
:database_type "DOUBLE PRECISION",
:semantic_type nil,
:table_id 2,
:coercion_strategy nil,
:name "TAX",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.936403Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 6,
:position 4,
:visibility_type "normal",
:display_name "Tax",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "The contact email for the account.",
:database_type "CHARACTER VARYING",
:semantic_type "type/Email",
:table_id 1,
:coercion_strategy nil,
:name "EMAIL",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.863684Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 7,
:position 2,
:visibility_type "normal",
:display_name "Email",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description
"The numerical product number. Only used internally. All external communication should use the title or EAN.",
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 3,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.957037Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 8,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description
"This is a unique ID for the product. It is also called the “Invoice number” or “Confirmation number” in customer facing emails and screens.",
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 2,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.933483Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 9,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description
"The raw, pre-tax cost of the order. Note that this might be different in the future from the product price due to promotions, credits, etc.",
:database_type "DOUBLE PRECISION",
:semantic_type nil,
:table_id 2,
:coercion_strategy nil,
:name "SUBTOTAL",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.927189Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 10,
:position 3,
:visibility_type "normal",
:display_name "Subtotal",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description
"The id of the user who made this order. Note that in some cases where an order was created on behalf of a customer who phoned the order in, this might be the employee who handled the request.",
:database_type "INTEGER",
:semantic_type "type/FK",
:table_id 2,
:coercion_strategy nil,
:name "USER_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 4,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.912991Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 11,
:position 1,
:visibility_type "normal",
:display_name "User ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description "The date of birth of the user",
:database_type "DATE",
:semantic_type nil,
:table_id 1,
:coercion_strategy nil,
:name "BIRTH_DATE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.894744Z",
:effective_type "type/Date",
:active true,
:parent_id nil,
:id 12,
:position 9,
:visibility_type "normal",
:display_name "Birth Date",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Date",
:points_of_interest nil}
{:description "The date and time an order was submitted.",
:database_type "TIMESTAMP",
:semantic_type "type/CreationTimestamp",
:table_id 2,
:coercion_strategy nil,
:name "CREATED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.916777Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 13,
:position 7,
:visibility_type "normal",
:display_name "Created At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description "The product ID. This is an internal identifier for the product, NOT the SKU.",
:database_type "INTEGER",
:semantic_type "type/FK",
:table_id 2,
:coercion_strategy nil,
:name "PRODUCT_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 8,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.919506Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 14,
:position 2,
:visibility_type "normal",
:display_name "Product ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description "The international article number. A 13 digit number uniquely identifying the product.",
:database_type "CHARACTER",
:semantic_type nil,
:table_id 3,
:coercion_strategy nil,
:name "EAN",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.948962Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 15,
:position 1,
:visibility_type "normal",
:display_name "Ean",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The average rating users have given the product. This ranges from 1 - 5",
:database_type "DOUBLE PRECISION",
:semantic_type "type/Score",
:table_id 3,
:coercion_strategy nil,
:name "RATING",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.946365Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 16,
:position 6,
:visibility_type "normal",
:display_name "Rating",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "The name of the product as it should be displayed to customers.",
:database_type "CHARACTER VARYING",
:semantic_type "type/Title",
:table_id 3,
:coercion_strategy nil,
:name "TITLE",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.952943Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 17,
:position 2,
:visibility_type "normal",
:display_name "Title",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget",
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 3,
:coercion_strategy nil,
:name "CATEGORY",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.947758Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 18,
:position 3,
:visibility_type "normal",
:display_name "Category",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The rating (on a scale of 1-5) the user left.",
:database_type "SMALLINT",
:semantic_type "type/Score",
:table_id 4,
:coercion_strategy nil,
:name "RATING",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.966952Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 19,
:position 3,
:visibility_type "normal",
:display_name "Rating",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 5,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.995757Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 20,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description nil,
:database_type "DOUBLE PRECISION",
:semantic_type "type/Longitude",
:table_id 6,
:coercion_strategy nil,
:name "LONGITUDE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.053358Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 21,
:position 14,
:visibility_type "normal",
:display_name "Longitude",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description nil,
:database_type "SMALLINT",
:semantic_type "type/Score",
:table_id 5,
:coercion_strategy nil,
:name "RATING",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.010696Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 22,
:position 4,
:visibility_type "normal",
:display_name "Rating",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 5,
:coercion_strategy nil,
:name "RATING_MAPPED",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.992076Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 23,
:position 5,
:visibility_type "normal",
:display_name "Rating Mapped",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 6,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.057988Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 24,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/FK",
:table_id 5,
:coercion_strategy nil,
:name "ACCOUNT_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 24,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.000851Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 25,
:position 1,
:visibility_type "normal",
:display_name "Account ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Email",
:table_id 5,
:coercion_strategy nil,
:name "EMAIL",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.993750Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 26,
:position 2,
:visibility_type "normal",
:display_name "Email",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type nil,
:table_id 5,
:coercion_strategy nil,
:name "DATE_RECEIVED",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.006054Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 27,
:position 3,
:visibility_type "normal",
:display_name "Date Received",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER LARGE OBJECT",
:semantic_type nil,
:table_id 5,
:coercion_strategy nil,
:name "BODY",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.997589Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 28,
:position 6,
:visibility_type "normal",
:display_name "Body",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 7,
:coercion_strategy nil,
:name "BUTTON_LABEL",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.098518Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 29,
:position 5,
:visibility_type "normal",
:display_name "Button Label",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description
"The channel through which we acquired this user. Valid values include: Affiliate, Facebook, Google, Organic and Twitter",
:database_type "CHARACTER VARYING",
:semantic_type "type/Source",
:table_id 1,
:coercion_strategy nil,
:name "SOURCE",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.880768Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 30,
:position 8,
:visibility_type "normal",
:display_name "Source",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type "type/CreationTimestamp",
:table_id 6,
:coercion_strategy nil,
:name "CREATED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.063064Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 31,
:position 7,
:visibility_type "normal",
:display_name "Created At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 7,
:coercion_strategy nil,
:name "EVENT",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.094978Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 32,
:position 2,
:visibility_type "normal",
:display_name "Event",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "INTEGER",
:semantic_type nil,
:table_id 6,
:coercion_strategy nil,
:name "SEATS",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.044794Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 33,
:position 6,
:visibility_type "normal",
:display_name "Seats",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description "The source of the product.",
:database_type "CHARACTER VARYING",
:semantic_type "type/Company",
:table_id 3,
:coercion_strategy nil,
:name "VENDOR",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.955812Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 34,
:position 4,
:visibility_type "normal",
:display_name "Vendor",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type nil,
:table_id 7,
:coercion_strategy nil,
:name "TIMESTAMP",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.089684Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 35,
:position 3,
:visibility_type "normal",
:display_name "Timestamp",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Name",
:table_id 6,
:coercion_strategy nil,
:name "LAST_NAME",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.029824Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 36,
:position 3,
:visibility_type "normal",
:display_name "Last Name",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Name",
:table_id 6,
:coercion_strategy nil,
:name "FIRST_NAME",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.033381Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 37,
:position 2,
:visibility_type "normal",
:display_name "First Name",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BOOLEAN",
:semantic_type nil,
:table_id 6,
:coercion_strategy nil,
:name "TRIAL_CONVERTED",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.049591Z",
:effective_type "type/Boolean",
:active true,
:parent_id nil,
:id 38,
:position 10,
:visibility_type "normal",
:display_name "Trial Converted",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Boolean",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type "type/CancelationTimestamp",
:table_id 6,
:coercion_strategy nil,
:name "CANCELED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.078035Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 39,
:position 9,
:visibility_type "normal",
:display_name "Canceled At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type nil,
:table_id 6,
:coercion_strategy nil,
:name "TRIAL_ENDS_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.037084Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 40,
:position 8,
:visibility_type "normal",
:display_name "Trial Ends At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Source",
:table_id 6,
:coercion_strategy nil,
:name "SOURCE",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.072954Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 41,
:position 5,
:visibility_type "normal",
:display_name "Source",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BOOLEAN",
:semantic_type nil,
:table_id 6,
:coercion_strategy nil,
:name "ACTIVE_SUBSCRIPTION",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.076132Z",
:effective_type "type/Boolean",
:active true,
:parent_id nil,
:id 42,
:position 11,
:visibility_type "normal",
:display_name "Active Subscription",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Boolean",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 6,
:coercion_strategy nil,
:name "PLAN",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.060369Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 43,
:position 4,
:visibility_type "normal",
:display_name "Plan",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description
"The list price of the product. Note that this is not always the price the product sold for due to discounts, promotions, etc.",
:database_type "DOUBLE PRECISION",
:semantic_type nil,
:table_id 3,
:coercion_strategy nil,
:name "PRICE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.958226Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 44,
:position 5,
:visibility_type "normal",
:display_name "Price",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/FK",
:table_id 7,
:coercion_strategy nil,
:name "ACCOUNT_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 24,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.093193Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 45,
:position 1,
:visibility_type "normal",
:display_name "Account ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Category",
:table_id 8,
:coercion_strategy nil,
:name "PLAN",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.108515Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 46,
:position 4,
:visibility_type "normal",
:display_name "Plan",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BOOLEAN",
:semantic_type nil,
:table_id 6,
:coercion_strategy nil,
:name "LEGACY_PLAN",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.070687Z",
:effective_type "type/Boolean",
:active true,
:parent_id nil,
:id 47,
:position 12,
:visibility_type "normal",
:display_name "Legacy Plan",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Boolean",
:points_of_interest nil}
{:description "The name of the user who owns an account",
:database_type "CHARACTER VARYING",
:semantic_type "type/Name",
:table_id 1,
:coercion_strategy nil,
:name "NAME",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.871361Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 48,
:position 4,
:visibility_type "normal",
:display_name "Name",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/URL",
:table_id 7,
:coercion_strategy nil,
:name "PAGE_URL",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.096400Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 49,
:position 4,
:visibility_type "normal",
:display_name "Page URL",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The date the user record was created. Also referred to as the user’s \"join date\"",
:database_type "TIMESTAMP",
:semantic_type "type/CreationTimestamp",
:table_id 1,
:coercion_strategy nil,
:name "CREATED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.888589Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 50,
:position 12,
:visibility_type "normal",
:display_name "Created At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description "The street address of the account’s billing address",
:database_type "CHARACTER VARYING",
:semantic_type nil,
:table_id 1,
:coercion_strategy nil,
:name "ADDRESS",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.898004Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 51,
:position 1,
:visibility_type "normal",
:display_name "Address",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description
"This is the latitude of the user on sign-up. It might be updated in the future to the last seen location.",
:database_type "DOUBLE PRECISION",
:semantic_type "type/Latitude",
:table_id 1,
:coercion_strategy nil,
:name "LATITUDE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.883248Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 52,
:position 11,
:visibility_type "normal",
:display_name "Latitude",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "The city of the account’s billing address",
:database_type "CHARACTER VARYING",
:semantic_type "type/City",
:table_id 1,
:coercion_strategy nil,
:name "CITY",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.874874Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 53,
:position 5,
:visibility_type "normal",
:display_name "City",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "This is the salted password of the user. It should not be visible",
:database_type "CHARACTER VARYING",
:semantic_type nil,
:table_id 1,
:coercion_strategy nil,
:name "PASSWORD",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.868884Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 54,
:position 3,
:visibility_type "normal",
:display_name "Password",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The day and time a review was written by a user.",
:database_type "TIMESTAMP",
:semantic_type "type/CreationTimestamp",
:table_id 4,
:coercion_strategy nil,
:name "CREATED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.970693Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 55,
:position 5,
:visibility_type "normal",
:display_name "Created At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER",
:semantic_type "type/Country",
:table_id 6,
:coercion_strategy nil,
:name "COUNTRY",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.027936Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 56,
:position 15,
:visibility_type "normal",
:display_name "Country",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "DOUBLE PRECISION",
:semantic_type "type/Latitude",
:table_id 6,
:coercion_strategy nil,
:name "LATITUDE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.047470Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 57,
:position 13,
:visibility_type "normal",
:display_name "Latitude",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description
"This is the longitude of the user on sign-up. It might be updated in the future to the last seen location.",
:database_type "DOUBLE PRECISION",
:semantic_type "type/Longitude",
:table_id 1,
:coercion_strategy nil,
:name "LONGITUDE",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.878744Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 58,
:position 6,
:visibility_type "normal",
:display_name "Longitude",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "A unique internal identifier for the review. Should not be used externally.",
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 4,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.969117Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 59,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 7,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.091626Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 60,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description "The postal code of the account’s billing address",
:database_type "CHARACTER",
:semantic_type "type/ZipCode",
:table_id 1,
:coercion_strategy nil,
:name "ZIP",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T19:48:00.338809Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 61,
:position 10,
:visibility_type "normal",
:display_name "Zip",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "CHARACTER VARYING",
:semantic_type "type/Email",
:table_id 6,
:coercion_strategy nil,
:name "EMAIL",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.066721Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 62,
:position 1,
:visibility_type "normal",
:display_name "Email",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description "The date the product was added to our catalog.",
:database_type "TIMESTAMP",
:semantic_type "type/CreationTimestamp",
:table_id 3,
:coercion_strategy nil,
:name "CREATED_AT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.954443Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 63,
:position 7,
:visibility_type "normal",
:display_name "Created At",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}
{:description nil,
:database_type "DOUBLE PRECISION",
:semantic_type nil,
:table_id 8,
:coercion_strategy nil,
:name "PAYMENT",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.117905Z",
:effective_type "type/Float",
:active true,
:parent_id nil,
:id 64,
:position 2,
:visibility_type "normal",
:display_name "Payment",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Float",
:points_of_interest nil}
{:description "The product the review was for",
:database_type "INTEGER",
:semantic_type "type/FK",
:table_id 4,
:coercion_strategy nil,
:name "PRODUCT_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 8,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.972233Z",
:effective_type "type/Integer",
:active true,
:parent_id nil,
:id 65,
:position 1,
:visibility_type "normal",
:display_name "Product ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Integer",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/FK",
:table_id 8,
:coercion_strategy nil,
:name "ACCOUNT_ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id 24,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.112761Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 66,
:position 1,
:visibility_type "normal",
:display_name "Account ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description "The user who left the review",
:database_type "CHARACTER VARYING",
:semantic_type nil,
:table_id 4,
:coercion_strategy nil,
:name "REVIEWER",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:56.973643Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 67,
:position 2,
:visibility_type "normal",
:display_name "Reviewer",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BIGINT",
:semantic_type "type/PK",
:table_id 8,
:coercion_strategy nil,
:name "ID",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.110031Z",
:effective_type "type/BigInteger",
:active true,
:parent_id nil,
:id 68,
:position 0,
:visibility_type "normal",
:display_name "ID",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/BigInteger",
:points_of_interest nil}
{:description "The review the user left. Limited to 2000 characters.",
:database_type "CHARACTER VARYING",
:semantic_type "type/Description",
:table_id 4,
:coercion_strategy nil,
:name "BODY",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T19:48:00.339704Z",
:effective_type "type/Text",
:active true,
:parent_id nil,
:id 69,
:position 4,
:visibility_type "normal",
:display_name "Body",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Text",
:points_of_interest nil}
{:description nil,
:database_type "BOOLEAN",
:semantic_type nil,
:table_id 8,
:coercion_strategy nil,
:name "EXPECTED_INVOICE",
:has_field_values "auto-list",
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.107209Z",
:effective_type "type/Boolean",
:active true,
:parent_id nil,
:id 70,
:position 3,
:visibility_type "normal",
:display_name "Expected Invoice",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/Boolean",
:points_of_interest nil}
{:description nil,
:database_type "TIMESTAMP",
:semantic_type nil,
:table_id 8,
:coercion_strategy nil,
:name "DATE_RECEIVED",
:has_field_values nil,
:settings nil,
:caveats nil,
:fk_target_field_id nil,
:is_defective_duplicate false,
:updated_at #t "2026-02-23T11:14:57.115865Z",
:effective_type "type/DateTime",
:active true,
:parent_id nil,
:id 71,
:position 5,
:visibility_type "normal",
:display_name "Date Received",
:created_at #t "2026-02-23T11:14:53.782096Z",
:base_type "type/DateTime",
:points_of_interest nil}),
:report_card
({:cache_invalidated_at nil,
:description "Sample orders joined with products",
:archived false,
:collection_position 1,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/BigInteger\",\"coercion_strategy\":null,\"description\":\"This is a unique ID for the product. It is also called the “Invoice number” or “Confirmation number” in customer facing emails and screens.\",\"display_name\":\"ID\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",9,null],\"fk_target_field_id\":null,\"id\":9,\"name\":\"ID\",\"semantic_type\":\"type/PK\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Integer\",\"coercion_strategy\":null,\"description\":\"The id of the user who made this order. Note that in some cases where an order was created on behalf of a customer who phoned the order in, this might be the employee who handled the request.\",\"display_name\":\"User ID\",\"effective_type\":\"type/Integer\",\"field_ref\":[\"field\",11,null],\"fk_target_field_id\":4,\"id\":11,\"name\":\"USER_ID\",\"semantic_type\":\"type/FK\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Integer\",\"coercion_strategy\":null,\"description\":\"The product ID. This is an internal identifier for the product, NOT the SKU.\",\"display_name\":\"Product ID\",\"effective_type\":\"type/Integer\",\"field_ref\":[\"field\",14,null],\"fk_target_field_id\":8,\"id\":14,\"name\":\"PRODUCT_ID\",\"semantic_type\":\"type/FK\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"The raw, pre-tax cost of the order. Note that this might be different in the future from the product price due to promotions, credits, etc.\",\"display_name\":\"Subtotal\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",10,null],\"fk_target_field_id\":null,\"id\":10,\"name\":\"SUBTOTAL\",\"semantic_type\":\"type/Currency\",\"settings\":{\"view_as\":null},\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"This is the amount of local and federal taxes that are collected on the purchase. Note that other governmental fees on some products are not included here, but instead are accounted for in the subtotal.\",\"display_name\":\"Tax\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",6,null],\"fk_target_field_id\":null,\"id\":6,\"name\":\"TAX\",\"semantic_type\":\"type/Currency\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"The total billed amount.\",\"display_name\":\"Total\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",5,null],\"fk_target_field_id\":null,\"id\":5,\"name\":\"TOTAL\",\"semantic_type\":\"type/Currency\",\"settings\":{\"currency\":\"USD\"},\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"Discount amount.\",\"display_name\":\"Discount\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",3,null],\"fk_target_field_id\":null,\"id\":3,\"name\":\"DISCOUNT\",\"semantic_type\":\"type/Discount\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,null],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"visibility_type\":\"normal\"},{\"base_type\":\"type/Integer\",\"coercion_strategy\":null,\"description\":\"Number of products bought.\",\"display_name\":\"Quantity\",\"effective_type\":\"type/Integer\",\"field_ref\":[\"field\",2,null],\"fk_target_field_id\":null,\"id\":2,\"name\":\"QUANTITY\",\"semantic_type\":\"type/Quantity\",\"settings\":{\"show_mini_bar\":false},\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The contact email for the account.\",\"display_name\":\"Customer Email\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",7,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":7,\"name\":\"EMAIL\",\"semantic_type\":\"type/Email\",\"settings\":{\"link_text\":\"\"},\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The state or province of the account’s billing address.\",\"display_name\":\"State\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",1,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":1,\"name\":\"STATE\",\"semantic_type\":\"type/State\",\"settings\":null,\"visibility_type\":\"normal\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Orders + People",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "model",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"expressions\":{\"Age\":[\"datetime-diff\",[\"field\",12,{\"base-type\":\"type/Date\",\"join-alias\":\"People - User\"}],[\"now\"],\"year\"]},\"joins\":[{\"alias\":\"People - User\",\"condition\":[\"=\",[\"field\",11,{\"base-type\":\"type/Integer\"}],[\"field\",4,{\"base-type\":\"type/BigInteger\",\"join-alias\":\"People - User\"}]],\"fields\":[[\"field\",7,{\"base-type\":\"type/Text\",\"join-alias\":\"People - User\"}],[\"field\",1,{\"base-type\":\"type/Text\",\"join-alias\":\"People - User\"}]],\"source-table\":1,\"strategy\":\"left-join\"}],\"source-table\":2},\"type\":\"query\"}",
:id 1,
:parameter_mappings "[]",
:display "table",
:archived_directly false,
:entity_id "_GiVL6zYmsnBb1oqLCp4u",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"table.cell_column\":\"SUBTOTAL\",\"table.columns\":[{\"enabled\":true,\"name\":\"ID\"},{\"enabled\":true,\"name\":\"USER_ID\"},{\"enabled\":true,\"name\":\"PRODUCT_ID\"},{\"enabled\":true,\"name\":\"SUBTOTAL\"},{\"enabled\":true,\"name\":\"TAX\"},{\"enabled\":true,\"name\":\"TOTAL\"},{\"enabled\":true,\"name\":\"DISCOUNT\"},{\"enabled\":true,\"name\":\"CREATED_AT\"},{\"enabled\":true,\"name\":\"QUANTITY\"},{\"enabled\":true,\"name\":\"EMAIL\"},{\"enabled\":true,\"name\":\"Age\"},{\"enabled\":true,\"name\":\"STATE\"}],\"table.pivot_column\":\"SOURCE\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Revenue in the US broken down by state",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/Text\",\"description\":\"The state or province of the account’s billing address.\",\"display_name\":\"State\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",\"STATE\",{\"base-type\":\"type/Text\"}],\"id\":1,\"name\":\"STATE\",\"semantic_type\":\"type/State\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"display_name\":\"Sum of Total\",\"effective_type\":\"type/Float\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Currency\",\"settings\":{\"currency\":\"USD\"}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue by state",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",\"TOTAL\",{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",\"STATE\",{\"base-type\":\"type/Text\"}]],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 2,
:parameter_mappings "[]",
:display "map",
:archived_directly false,
:entity_id "jjO5LcBp8qNILJFiYZoVt",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"map.colors\":[\"rgb(229, 229, 241)\",\"rgb(192, 192, 218)\",\"rgb(155, 155, 194)\",\"rgb(118, 119, 171)\",\"hsl(239, 29.5%, 39.3%)\"],\"map.region\":\"us_states\",\"map.type\":\"region\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows the distribution of the product categories along the scale of customer ratings",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The average rating users have given the product. This ranges from 1 - 5\",\"database_type\":\"DOUBLE PRECISION\",\"semantic_type\":\"type/Score\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"RATING\",\"lib/original-name\":\"RATING\",\"lib/breakout?\":true,\"name\":\"RATING\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"RATING\",\"lib/original-display-name\":\"Rating\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",16,{\"source-field\":14}],\"effective_type\":\"type/Float\",\"active\":true,\"id\":16,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__RATING\",\"position\":6,\"visibility_type\":\"normal\",\"display_name\":\"Product → Rating\",\"fingerprint\":{\"global\":{\"distinct-count\":23,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":0.0,\"q1\":3.5120465053408525,\"q3\":4.216124969497314,\"max\":5.0,\"sd\":1.3605488657451452,\"avg\":3.4715}}},\"base_type\":\"type/Float\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":57,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":70.0,\"q1\":105.0,\"q3\":370.0,\"max\":1093.0,\"sd\":229.88812521865958,\"avg\":281.6060606060606}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Customer satisfaction per category",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",16,{\"base-type\":\"type/Float\",\"source-field\":14}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"filter\":[\"!=\",[\"field\",17,{\"base-type\":\"type/Text\",\"source-field\":14}],\"Incredible Aluminum Knife\"],\"order-by\":[[\"desc\",[\"field\",16,{\"base-type\":\"type/Float\",\"source-field\":14,\"binning\":{\"strategy\":\"default\"}}]]],\"source-table\":2},\"type\":\"query\"}",
:id 3,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "OJ-I03ZsQ7IBrzr29B_8o",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"RATING\",\"CATEGORY\"],\"graph.label_value_formatting\":\"compact\",\"graph.metrics\":[\"count\"],\"graph.show_values\":true,\"graph.x_axis.scale\":\"histogram\",\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"series_settings\":{\"Doohickey\":{\"color\":\"#7172AD\"},\"Gadget\":{\"color\":\"#999AC4\"},\"Gizmo\":{\"color\":\"#227FD2\"},\"Widget\":{\"color\":\"#C7EAEA\"}},\"stackable.stack_type\":\"stacked\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows a distribution of orders broken down by product categories across our customers' age groups",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/Decimal\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/Decimal\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\",\"binning\":{\"strategy\":\"num-bins\",\"num-bins\":10,\"min-value\":20,\"max-value\":70,\"bin-width\":5}}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"display_name\":\"Products → Category\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",18,{\"base-type\":\"type/Text\",\"join-alias\":\"Products\"}],\"fk_target_field_id\":null,\"id\":18,\"name\":\"CATEGORY\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Product category orders per age group",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\",\"binning\":{\"strategy\":\"num-bins\",\"num-bins\":10}}],[\"field\",18,{\"base-type\":\"type/Text\",\"join-alias\":\"Products\"}]],\"filter\":[\"between\",[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],20,70],\"joins\":[{\"alias\":\"Products\",\"condition\":[\"=\",[\"field\",\"PRODUCT_ID\",{\"base-type\":\"type/Integer\"}],[\"field\",8,{\"base-type\":\"type/BigInteger\",\"join-alias\":\"Products\"}]],\"source-table\":3,\"strategy\":\"left-join\"}],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 4,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "WMub5k6vo0zGP24qXQFNu",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\",\"CATEGORY\"],\"graph.metrics\":[\"count\"],\"graph.show_values\":true,\"graph.x_axis.scale\":\"linear\",\"stackable.stack_type\":\"stacked\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Feedback on our products via weekly survey",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 5,
:result_metadata
"[{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/PK\",\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"ID\",\"lib/original-name\":\"ID\",\"name\":\"ID\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"ID\",\"lib/original-display-name\":\"ID\",\"source\":\"fields\",\"field_ref\":[\"field\",20,null],\"effective_type\":\"type/BigInteger\",\"active\":true,\"id\":20,\"lib/desired-column-alias\":\"ID\",\"position\":0,\"visibility_type\":\"normal\",\"display_name\":\"ID\",\"fingerprint\":null,\"base_type\":\"type/BigInteger\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/FK\",\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"ACCOUNT_ID\",\"lib/original-name\":\"ACCOUNT_ID\",\"name\":\"ACCOUNT_ID\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"ACCOUNT_ID\",\"lib/original-display-name\":\"Account ID\",\"lib/external-remap\":{\"lib/type\":\"metadata.column.remapping/external\",\"id\":4,\"name\":\"Account ID\",\"field-id\":62},\"source\":\"fields\",\"fk_target_field_id\":24,\"field_ref\":[\"field\",25,null],\"effective_type\":\"type/BigInteger\",\"remapped_to\":\"EMAIL_2\",\"active\":true,\"id\":25,\"lib/desired-column-alias\":\"ACCOUNT_ID\",\"position\":1,\"visibility_type\":\"normal\",\"options\":{\"metabase.query-processor.middleware.add-remaps/original-field-dimension-id\":4},\"display_name\":\"Account ID\",\"fingerprint\":{\"global\":{\"distinct-count\":642,\"nil%\":0.0}},\"base_type\":\"type/BigInteger\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Email\",\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"EMAIL\",\"lib/original-name\":\"EMAIL\",\"name\":\"EMAIL\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"EMAIL\",\"lib/original-display-name\":\"Email\",\"source\":\"fields\",\"field_ref\":[\"field\",26,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":26,\"lib/desired-column-alias\":\"EMAIL\",\"position\":2,\"visibility_type\":\"normal\",\"display_name\":\"Email\",\"fingerprint\":{\"global\":{\"distinct-count\":642,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":1.0,\"percent-state\":0.0,\"average-length\":28.327102803738317}}},\"base_type\":\"type/Text\"},{\"database_type\":\"TIMESTAMP\",\"semantic_type\":null,\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"DATE_RECEIVED\",\"lib/original-name\":\"DATE_RECEIVED\",\"name\":\"DATE_RECEIVED\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"DATE_RECEIVED\",\"lib/original-display-name\":\"Date Received\",\"source\":\"fields\",\"field_ref\":[\"field\",27,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":27,\"lib/desired-column-alias\":\"DATE_RECEIVED\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Date Received\",\"fingerprint\":{\"global\":{\"distinct-count\":576,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2020-11-20T00:00:00Z\",\"latest\":\"2031-12-01T00:00:00Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"SMALLINT\",\"semantic_type\":\"type/Score\",\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"RATING\",\"lib/original-name\":\"RATING\",\"name\":\"RATING\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"RATING\",\"lib/original-display-name\":\"Rating\",\"source\":\"fields\",\"field_ref\":[\"field\",22,null],\"effective_type\":\"type/Integer\",\"active\":true,\"id\":22,\"lib/desired-column-alias\":\"RATING\",\"position\":4,\"visibility_type\":\"normal\",\"display_name\":\"Rating\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":1.0,\"q1\":2.7545289729206877,\"q3\":4.004191340512663,\"max\":5.0,\"sd\":0.8137255616667736,\"avg\":3.3629283489096573}}},\"base_type\":\"type/Integer\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"RATING_MAPPED\",\"lib/original-name\":\"RATING_MAPPED\",\"name\":\"RATING_MAPPED\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"RATING_MAPPED\",\"lib/original-display-name\":\"Rating Mapped\",\"source\":\"fields\",\"field_ref\":[\"field\",23,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":23,\"lib/desired-column-alias\":\"RATING_MAPPED\",\"position\":5,\"visibility_type\":\"normal\",\"display_name\":\"Rating Mapped\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.453271028037383}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER LARGE OBJECT\",\"semantic_type\":null,\"table_id\":5,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"BODY\",\"lib/original-name\":\"BODY\",\"name\":\"BODY\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"BODY\",\"lib/original-display-name\":\"Body\",\"source\":\"fields\",\"field_ref\":[\"field\",28,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":28,\"lib/desired-column-alias\":\"BODY\",\"position\":6,\"visibility_type\":\"normal\",\"display_name\":\"Body\",\"fingerprint\":{\"global\":{\"distinct-count\":642,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":438.15264797507785}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Email\",\"table_id\":6,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"EMAIL_2\",\"lib/original-name\":\"EMAIL\",\"lib/breakout?\":false,\"name\":\"EMAIL_2\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"EMAIL\",\"lib/original-display-name\":\"Email\",\"source\":\"fields\",\"remapped_from\":\"ACCOUNT_ID\",\"fk_field_id\":25,\"field_ref\":[\"field\",62,{\"source-field\":25}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":62,\"lib/desired-column-alias\":\"ACCOUNTS__via__ACCOUNT_ID__EMAIL\",\"position\":1,\"visibility_type\":\"normal\",\"options\":{\"metabase.query-processor.middleware.add-remaps/new-field-dimension-id\":4},\"display_name\":\"Account ID\",\"fingerprint\":{\"global\":{\"distinct-count\":2494,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":1.0,\"percent-state\":0.0,\"average-length\":28.185971943887775}}},\"base_type\":\"type/Text\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Customer survey responses",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\"time-interval\",[\"field\",27,{\"base-type\":\"type/DateTime\"}],-12,\"month\"],\"order-by\":[[\"desc\",[\"field\",27,{\"base-type\":\"type/DateTime\"}]]],\"source-table\":5},\"type\":\"query\"}",
:id 5,
:parameter_mappings "[]",
:display "table",
:archived_directly false,
:entity_id "Jxa0svP68DfXubV_wD3os",
:collection_preview true,
:visualization_settings
"{\"column_settings\":{\"[\\\"name\\\",\\\"DATE_RECEIVED\\\"]\":{\"date_abbreviate\":true,\"date_style\":\"dddd, MMMM D, YYYY\",\"time_enabled\":null}},\"table.cell_column\":\"BODY\",\"table.column_formatting\":[{\"color\":\"#F7C4C4\",\"columns\":[\"RATING\"],\"highlight_row\":true,\"id\":2,\"operator\":\"<\",\"type\":\"single\",\"value\":3},{\"color\":\"#FBE499\",\"columns\":[\"RATING\"],\"highlight_row\":true,\"id\":1,\"operator\":\"=\",\"type\":\"single\",\"value\":3},{\"color\":\"#A7D07C\",\"colors\":[\"#ED6E6E\",\"#FFFFFF\",\"#84BB4C\"],\"columns\":[\"RATING\"],\"highlight_row\":true,\"id\":0,\"max_type\":null,\"max_value\":100,\"min_type\":null,\"min_value\":0,\"operator\":\">\",\"type\":\"single\",\"value\":3}],\"table.columns\":[{\"enabled\":true,\"name\":\"ID\"},{\"enabled\":true,\"name\":\"DATE_RECEIVED\"},{\"enabled\":false,\"name\":\"ACCOUNT_ID\"},{\"enabled\":true,\"name\":\"EMAIL\"},{\"enabled\":true,\"name\":\"RATING\"},{\"enabled\":false,\"name\":\"RATING_MAPPED\"},{\"enabled\":true,\"name\":\"BODY\"}],\"table.pivot_column\":\"RATING\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Flow from viewing our website (empty) to checkout and subscribe",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 7,
:result_metadata
"[{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":7,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"BUTTON_LABEL\",\"lib/original-name\":\"BUTTON_LABEL\",\"lib/breakout?\":false,\"name\":\"BUTTON_LABEL\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"BUTTON_LABEL\",\"lib/original-display-name\":\"Button Label\",\"source\":\"fields\",\"field_ref\":[\"field\",29,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":29,\"lib/desired-column-alias\":\"BUTTON_LABEL\",\"position\":5,\"visibility_type\":\"normal\",\"display_name\":\"Button Label\",\"fingerprint\":{\"global\":{\"distinct-count\":6,\"nil%\":0.8698},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":1.0552}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"lib/breakout?\":false,\"name\":\"count\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"count\",\"source\":\"fields\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":975.0,\"q1\":1011.75,\"q3\":1065.0,\"max\":1071.0,\"sd\":38.86129179530706,\"avg\":1036.8}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Checkout funnel",
:last_used_at #t "2026-02-23T12:54:29.140731Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\"not-empty\",[\"field\",\"BUTTON_LABEL\",{\"base-type\":\"type/Text\"}]],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",29,{\"base-type\":\"type/Text\"}]],\"source-table\":7}},\"type\":\"query\"}",
:id 6,
:parameter_mappings "[]",
:display "funnel",
:archived_directly false,
:entity_id "UUZZsw19IuPTqdhho99oc",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"funnel.order_dimension\":\"BUTTON_LABEL\",\"funnel.rows\":[{\"enabled\":true,\"key\":\"Create Item\",\"name\":\"Create Item\"},{\"enabled\":true,\"key\":\"Invite\",\"name\":\"Invite\"},{\"enabled\":true,\"key\":\"Subscribe\",\"name\":\"Subscribe\"},{\"enabled\":true,\"key\":\"Signup\",\"name\":\"Signup\"},{\"enabled\":true,\"key\":\"Checkout\",\"name\":\"Checkout\"}]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Orders for each product, grouped by product category",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The name of the product as it should be displayed to customers.\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Title\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"TITLE\",\"lib/original-name\":\"TITLE\",\"lib/breakout?\":false,\"name\":\"TITLE\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"PRODUCTS__via__PRODUCT_ID__TITLE\",\"lib/original-display-name\":\"Title\",\"lib/original-fk-field-id\":14,\"source\":\"fields\",\"field_ref\":[\"field\",17,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":17,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__TITLE\",\"position\":2,\"visibility_type\":\"normal\",\"display_name\":\"Product → Title\",\"fingerprint\":{\"global\":{\"distinct-count\":199,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":21.495}}},\"base_type\":\"type/Text\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":false,\"name\":\"CATEGORY\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"lib/original-display-name\":\"Category\",\"lib/original-fk-field-id\":14,\"source\":\"fields\",\"field_ref\":[\"field\",18,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"lib/breakout?\":false,\"name\":\"count\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"count\",\"source\":\"fields\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":11,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":105.0,\"q1\":105.7090055512642,\"q3\":113.19615242270663,\"max\":120.0,\"sd\":4.945860740208771,\"avg\":109.6923076923077}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Product breakdown",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\">=\",[\"field\",\"count\",{\"base-type\":\"type/Integer\"}],105],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",17,{\"base-type\":\"type/Text\",\"source-field\":14}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"source-table\":2}},\"type\":\"query\"}",
:id 7,
:parameter_mappings "[]",
:display "pie",
:archived_directly false,
:entity_id "RpKYsFwHfjcckbgj4oBKK",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"TITLE\"],\"graph.metrics\":[\"count\"],\"graph.series_order\":null,\"graph.series_order_dimension\":null,\"graph.show_values\":true,\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"pie.decimal_places\":2,\"pie.dimension\":[\"CATEGORY\",\"TITLE\",\"count\"],\"pie.percent_visibility\":\"legend\",\"pie.rows\":[{\"color\":\"#51528D\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Doohickey\",\"name\":\"Doohickey\",\"originalName\":\"Doohickey\"},{\"color\":\"#8A5EB0\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Gadget\",\"name\":\"Gadget\",\"originalName\":\"Gadget\"},{\"color\":\"#69C8C8\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Gizmo\",\"name\":\"Gizmo\",\"originalName\":\"Gizmo\"},{\"color\":\"#227FD2\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Widget\",\"name\":\"Widget\",\"originalName\":\"Widget\"}],\"pie.slice_threshold\":11,\"pie.sort_rows\":false,\"series_settings\":{\"count\":{\"color\":\"#999AC4\"}},\"stackable.stack_type\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Analysis of discounts given vs. the size of the order",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"quarter\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"quarter\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"quarter\",\"display_name\":\"Created At: Quarter\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"description\":\"Number of products bought.\",\"database_type\":\"NUMERIC\",\"semantic_type\":\"type/Quantity\",\"table_id\":2,\"lib/deduplicated-name\":\"QUANTITY\",\"lib/original-name\":\"QUANTITY\",\"lib/breakout?\":true,\"binning_info\":{\"binning_strategy\":\"num-bins\",\"strategy\":\"num-bins\",\"min_value\":0.0,\"max_value\":100.0,\"num_bins\":8,\"bin_width\":12.5},\"name\":\"QUANTITY\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"QUANTITY\",\"lib/original-display-name\":\"Quantity\",\"source\":\"breakout\",\"metabase.lib.field/binning\":{\"strategy\":\"num-bins\",\"min-value\":0.0,\"max-value\":100.0,\"num-bins\":8,\"bin-width\":12.5},\"field_ref\":[\"field\",2,{\"binning\":{\"strategy\":\"num-bins\",\"min-value\":0.0,\"max-value\":100.0,\"num-bins\":8,\"bin-width\":12.5}}],\"lib/original-binning\":{\"strategy\":\"num-bins\",\"min-value\":0.0,\"max-value\":100.0,\"num-bins\":8,\"bin-width\":12.5},\"effective_type\":\"type/Decimal\",\"active\":true,\"id\":2,\"lib/desired-column-alias\":\"QUANTITY\",\"position\":8,\"visibility_type\":\"normal\",\"display_name\":\"Quantity: 8 bins\",\"fingerprint\":{\"global\":{\"distinct-count\":62,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":0.0,\"q1\":1.755882607764982,\"q3\":4.882654507928044,\"max\":100.0,\"sd\":4.214258386403798,\"avg\":3.7015}}},\"base_type\":\"type/Decimal\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":177,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":20.95809834572766,\"q1\":93.71778101397813,\"q3\":12864.142636111297,\"max\":43186.48117654797,\"sd\":13661.41283269102,\"avg\":8534.585779947069}}},\"base_type\":\"type/Float\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":\"type/Discount\",\"lib/deduplicated-name\":\"sum_2\",\"lib/original-name\":\"sum\",\"name\":\"sum_2\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",1],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum_2\",\"display_name\":\"Sum of Discount\",\"fingerprint\":{\"global\":{\"distinct-count\":88,\"nil%\":0.5084745762711864},\"type\":{\"type/Number\":{\"min\":1.5030327089601887,\"q1\":10.431821917042786,\"q3\":191.37331425402215,\"max\":302.4567767826503,\"sd\":93.38028022351212,\"avg\":114.42325088818538}}},\"base_type\":\"type/Float\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",2],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":67,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":1.0,\"q1\":1.2600882835670644,\"q3\":225.5,\"max\":464.0,\"sd\":158.82906995224747,\"avg\":105.98870056497175}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Total order amount vs. discount given",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",5,{\"base-type\":\"type/Float\"}]],[\"sum\",[\"field\",3,{\"base-type\":\"type/Float\"}]],[\"count\"]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],[\"field\",2,{\"base-type\":\"type/Integer\",\"binning\":{\"strategy\":\"default\"}}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"source-table\":2},\"type\":\"query\"}",
:id 8,
:parameter_mappings "[]",
:display "scatter",
:archived_directly false,
:entity_id "X8HNuB_i3j2uNFnsx3vQ0",
:collection_preview true,
:visualization_settings
"{\"column_settings\":{\"[\\\"name\\\",\\\"sum_2\\\"]\":{\"decimals\":0}},\"graph.dimensions\":[\"sum\",\"CATEGORY\"],\"graph.metrics\":[\"sum_2\"],\"graph.series_order\":null,\"graph.series_order_dimension\":null,\"graph.show_trendline\":false,\"graph.tooltip_columns\":[\"[\\\"name\\\",\\\"count\\\"]\"],\"graph.x_axis.title_text\":\"Total\",\"graph.y_axis.title_text\":\"Discount\",\"scatter.bubble\":\"count\",\"series_settings\":{\"Doohickey\":{\"color\":\"#7172AD\"},\"Gadget\":{\"color\":\"#999AC4\"},\"Gizmo\":{\"color\":\"#C7EAEA\"},\"Widget\":{\"color\":\"#227FD2\"},\"sum_2\":{\"color\":\"#7172AD\"}}}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Canonical metric for revenue across all product lines",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"active\":true,\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"database_type\":\"TIMESTAMP\",\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Quarter\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"nfc_path\":null,\"parent_id\":null,\"position\":7,\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"source\":\"breakout\",\"table_id\":2,\"unit\":\"quarter\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"display_name\":\"Sum of Total\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Currency\",\"settings\":{\"currency\":\"USD\"},\"source\":\"aggregation\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue",
:last_used_at #t "2026-02-23T19:43:47.009035Z",
:type "metric",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",5,{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-12,\"quarter\",{\"include-current\":true}],\"source-table\":2},\"type\":\"query\"}",
:id 9,
:parameter_mappings "[]",
:display "line",
:archived_directly false,
:entity_id "skXR69-dlhJST5C7Rd9nR",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"CREATED_AT\"],\"graph.metrics\":[\"sum\"]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Orders placed per quarter broken down by source and formatted to highlight best and worst quarters",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The channel through which we acquired this user. Valid values include: Affiliate, Facebook, Google, Organic and Twitter\",\"lib/type\":\"metadata/column\",\"qp/implicit-field?\":true,\"base-type\":\"type/Text\",\"lib/deduplicated-name\":\"SOURCE\",\"semantic-type\":\"type/Source\",\"lib/original-name\":\"SOURCE\",\"lib/breakout?\":true,\"table-id\":1,\"name\":\"SOURCE\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"SOURCE\",\"lib/original-display-name\":\"Source\",\"database-type\":\"CHARACTER VARYING\",\"effective-type\":\"type/Text\",\"active\":true,\"id\":30,\"visibility-type\":\"normal\",\"lib/desired-column-alias\":\"PEOPLE__via__USER_ID__SOURCE\",\"display-name\":\"User → Source\",\"position\":8,\"fk-field-id\":11,\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":7.4084}}}},{\"description\":\"The date and time an order was submitted.\",\"inherited-temporal-unit\":\"quarter\",\"lib/type\":\"metadata/column\",\"base-type\":\"type/DateTime\",\"lib/deduplicated-name\":\"CREATED_AT\",\"semantic-type\":\"type/CreationTimestamp\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"table-id\":2,\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"database-type\":\"TIMESTAMP\",\"effective-type\":\"type/DateTime\",\"active\":true,\"id\":13,\"visibility-type\":\"normal\",\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"display-name\":\"Created At: Quarter\",\"position\":7,\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}}},{\"lib/type\":\"metadata/column\",\"base-type\":\"type/Float\",\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"effective-type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display-name\":\"Sum of Total\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Orders according to sources per quarter",
:last_used_at #t "2026-02-23T19:43:47.009035Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",9]],\"breakout\":[[\"field\",30,{\"base-type\":\"type/Text\",\"source-field\":11}],[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-2,\"year\",{\"include-current\":true}],\"source-table\":2},\"type\":\"query\"}",
:id 10,
:parameter_mappings "[]",
:display "pivot",
:archived_directly false,
:entity_id "km2d9-ZqHrlAM79yPh13G",
:collection_preview true,
:visualization_settings
"{\"column_settings\":{\"[\\\"name\\\",\\\"CREATED_AT\\\"]\":{\"column_title\":\"Date\"}},\"pivot_table.column_split\":{\"columns\":[\"SOURCE\"],\"rows\":[\"CREATED_AT\"],\"values\":[\"sum\"]},\"pivot_table.column_widths\":{\"leftHeaderWidths\":[135],\"totalLeftHeaderWidths\":135,\"valueHeaderWidths\":{\"0\":148,\"1\":158,\"2\":159,\"3\":144,\"4\":139,\"5\":124}},\"table.column_formatting\":[{\"color\":\"#509EE3\",\"colors\":[\"white\",\"#A7D07C\"],\"columns\":[\"sum\"],\"highlight_row\":false,\"id\":0,\"max_type\":null,\"max_value\":100,\"min_type\":null,\"min_value\":0,\"operator\":\"=\",\"type\":\"range\",\"value\":\"\"}]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Sankey flow from visiting our website to taking an action",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 7,
:result_metadata
"[{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":7,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"BUTTON_LABEL\",\"lib/original-name\":\"BUTTON_LABEL\",\"lib/breakout?\":false,\"name\":\"BUTTON_LABEL\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"BUTTON_LABEL\",\"lib/original-display-name\":\"Button Label\",\"source\":\"fields\",\"field_ref\":[\"field\",29,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":29,\"lib/desired-column-alias\":\"BUTTON_LABEL\",\"position\":5,\"visibility_type\":\"normal\",\"display_name\":\"Button Label\",\"fingerprint\":{\"global\":{\"distinct-count\":6,\"nil%\":0.8698},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":1.0552}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":7,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"EVENT\",\"lib/original-name\":\"EVENT\",\"lib/breakout?\":false,\"name\":\"EVENT\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"EVENT\",\"lib/original-display-name\":\"Event\",\"source\":\"fields\",\"field_ref\":[\"field\",32,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":32,\"lib/desired-column-alias\":\"EVENT\",\"position\":2,\"visibility_type\":\"normal\",\"display_name\":\"Event\",\"fingerprint\":{\"global\":{\"distinct-count\":2,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":11.3906}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"lib/breakout?\":false,\"name\":\"count\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"count\",\"source\":\"fields\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":975.0,\"q1\":1011.75,\"q3\":1065.0,\"max\":1071.0,\"sd\":38.86129179530706,\"avg\":1036.8}}},\"base_type\":\"type/BigInteger\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":null,\"lib/expression-name\":\"Step\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"Step\",\"lib/original-name\":\"Step\",\"name\":\"Step\",\"lib/source\":\"source/expressions\",\"lib/source-column-alias\":\"Step\",\"source\":\"fields\",\"field_ref\":[\"expression\",\"Step\"],\"effective_type\":\"type/Text\",\"lib/desired-column-alias\":\"Step\",\"display_name\":\"Step\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":8.0}}},\"base_type\":\"type/Text\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "User flow diagram",
:last_used_at #t "2026-02-23T12:54:29.140731Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"expressions\":{\"Step\":[\"case\",[[[\"is-null\",[\"field\",\"BUTTON_LABEL\",{\"base-type\":\"type/Text\"}]],\"Bounced\"]],{\"default\":[\"field\",\"BUTTON_LABEL\",{\"base-type\":\"type/Text\"}]}]},\"filter\":[\"!=\",[\"expression\",\"Step\",{\"base-type\":\"type/Text\"}],\"Bounced\"],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",29,{\"base-type\":\"type/Text\"}],[\"field\",32,{\"base-type\":\"type/Text\"}]],\"source-table\":7}},\"type\":\"query\"}",
:id 11,
:parameter_mappings "[]",
:display "sankey",
:archived_directly false,
:entity_id "9VE9Z6tAkyzO3GeQVXtin",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"sankey.edge_color\":\"source\",\"sankey.node_align\":\"right\",\"sankey.show_edge_labels\":true,\"sankey.source\":\"EVENT\",\"sankey.target\":\"Step\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Cumulative revenue overlaid with number of orders placed each month",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"quarter\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"quarter\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"quarter\",\"display_name\":\"Created At: Quarter\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":37,\"nil%\":0.1},\"type\":{\"type/Number\":{\"min\":19878.640993177505,\"q1\":28620.297685934947,\"q3\":39045.94440543998,\"max\":43535.518815369454,\"sd\":5756.094724745224,\"avg\":34234.70338751517}}},\"base_type\":\"type/Float\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"sum_2\",\"lib/original-name\":\"sum\",\"name\":\"sum_2\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",1],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"sum_2\",\"display_name\":\"Sum of Quantity\",\"fingerprint\":{\"global\":{\"distinct-count\":40,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":202.0,\"q1\":623.0,\"q3\":1923.5,\"max\":2630.0,\"sd\":734.3309841146355,\"avg\":1298.825}}},\"base_type\":\"type/BigInteger\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":\"type/Discount\",\"lib/deduplicated-name\":\"sum_3\",\"lib/original-name\":\"sum\",\"name\":\"sum_3\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",2],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum_3\",\"display_name\":\"Sum of Discount\",\"fingerprint\":{\"global\":{\"distinct-count\":40,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":28.05522447069486,\"q1\":174.34418384765237,\"q3\":232.9906260927989,\"max\":302.4567767826503,\"sd\":66.22303526422644,\"avg\":191.49152439651462}}},\"base_type\":\"type/Float\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",3],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":38,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":73.0,\"q1\":332.5,\"q3\":429.5,\"max\":467.0,\"sd\":105.26609749606602,\"avg\":360.15}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue and orders over time",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",9],[\"sum\",[\"field\",2,{\"base-type\":\"type/Integer\"}]],[\"sum\",[\"field\",3,{\"base-type\":\"type/Float\"}]],[\"count\"]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-2,\"year\",{\"include-current\":true}],\"source-table\":2},\"type\":\"query\"}",
:id 12,
:parameter_mappings "[]",
:display "combo",
:archived_directly false,
:entity_id "VFCGVYPVtLzCtt4teeoW4",
:collection_preview true,
:visualization_settings
"{\"column_settings\":{},\"graph.dimensions\":[\"CREATED_AT\"],\"graph.label_value_formatting\":\"compact\",\"graph.label_value_frequency\":\"fit\",\"graph.metrics\":[\"sum\",\"sum_2\"],\"graph.series_order\":null,\"graph.series_order_dimension\":null,\"graph.show_trendline\":false,\"graph.show_values\":true,\"graph.tooltip_columns\":[\"[\\\"name\\\",\\\"count\\\"]\",\"[\\\"name\\\",\\\"sum_3\\\"]\"],\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"series_settings\":{\"sum\":{\"color\":\"#88BF4D\",\"line.interpolate\":\"linear\",\"line.marker_enabled\":false,\"line.size\":\"L\",\"line.style\":\"solid\",\"title\":\"Revenue\"},\"sum_2\":{\"color\":\"#7172AD\",\"title\":\"Orders\"}},\"stackable.stack_type\":\"stacked\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Monthly revenue broken down by products",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"month\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"month\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"month\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"month\",\"display_name\":\"Created At: Month\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":16,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":7964.421789154249,\"q1\":11002.236740543147,\"q3\":13916.514530548517,\"max\":14870.965932493753,\"sd\":2185.7490840675837,\"avg\":12137.14505798909}}},\"base_type\":\"type/Float\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"avg\",\"lib/original-name\":\"avg\",\"name\":\"avg\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"avg\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",1],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"avg\",\"display_name\":\"Average of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":16,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":79.6442178915425,\"q1\":84.87314355167331,\"q3\":90.16751604831889,\"max\":95.94171569350807,\"sd\":4.551518432822324,\"avg\":87.35037077070169}}},\"base_type\":\"type/Float\"},{\"database_type\":\"DOUBLE PRECISION\",\"semantic_type\":null,\"lib/deduplicated-name\":\"max\",\"lib/original-name\":\"max\",\"name\":\"max\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"max\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",2],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"max\",\"display_name\":\"Max of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":16,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":132.67312547576884,\"q1\":150.74040629997404,\"q3\":156.9340052655229,\"max\":158.4190052655229,\"sd\":6.132452440391181,\"avg\":152.5964043543571}}},\"base_type\":\"type/Float\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":\"type/Discount\",\"lib/deduplicated-name\":\"sum_2\",\"lib/original-name\":\"sum\",\"name\":\"sum_2\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",3],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum_2\",\"display_name\":\"Sum of Discount\",\"fingerprint\":{\"global\":{\"distinct-count\":16,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":23.50010582323818,\"q1\":59.909314722591276,\"q3\":77.56127617998636,\"max\":110.72998819991292,\"sd\":20.472145174127174,\"avg\":67.58078379166977}}},\"base_type\":\"type/Float\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue by product category",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",9],[\"avg\",[\"field\",5,{\"base-type\":\"type/Float\"}]],[\"max\",[\"field\",5,{\"base-type\":\"type/Float\"}]],[\"sum\",[\"field\",3,{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\",\"original-temporal-unit\":\"quarter\"}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-4,\"month\"],\"source-table\":2},\"type\":\"query\"}",
:id 13,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "-6yAP_G1UZ7xZc4E65Tvy",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"CREATED_AT\",\"CATEGORY\"],\"graph.label_value_formatting\":\"compact\",\"graph.metrics\":[\"sum\",\"avg\",\"max\",\"sum_2\"],\"graph.show_stack_values\":\"all\",\"graph.show_values\":true,\"graph.tooltip_columns\":[\"[\\\"name\\\",\\\"sum_2\\\"]\",\"[\\\"name\\\",\\\"avg\\\"]\",\"[\\\"name\\\",\\\"max\\\"]\"],\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"series_settings\":{\"Doohickey\":{\"color\":\"#7172AD\"},\"Gadget\":{\"color\":\"#A989C5\"},\"Gizmo\":{\"color\":\"#C7EAEA\"},\"Widget\":{\"color\":\"#227FD2\"}},\"stackable.stack_type\":\"stacked\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Number of seats in an average subscription, showing increase and decrease",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 6,
:result_metadata
"[{\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":6,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":false,\"unit\":\"year\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"fields\",\"field_ref\":[\"field\",31,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":31,\"lib/desired-column-alias\":\"CREATED_AT\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"year\",\"display_name\":\"Created At: Year\",\"fingerprint\":{\"global\":{\"distinct-count\":2495,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2020-09-15T16:11:50Z\",\"latest\":\"2031-10-10T19:14:48Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BIGINT\",\"semantic_type\":null,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"lib/breakout?\":false,\"name\":\"sum\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"sum\",\"source\":\"fields\",\"field_ref\":[\"field\",\"sum\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Seats\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":1932.0,\"q1\":3090.5,\"q3\":4546.0,\"max\":4680.0,\"sd\":1269.99169944794,\"avg\":3818.25}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Subscription seats over time",
:last_used_at #t "2026-02-23T12:54:29.140731Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\"time-interval\",[\"field\",\"CREATED_AT\",{\"base-type\":\"type/DateTime\",\"inherited-temporal-unit\":\"year\"}],-3,\"year\",{\"include-current\":true}],\"source-query\":{\"aggregation\":[[\"sum\",[\"field\",33,{\"base-type\":\"type/Integer\"}]]],\"breakout\":[[\"field\",31,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"year\",\"original-temporal-unit\":\"month\"}]],\"source-table\":6}},\"type\":\"query\"}",
:id 14,
:parameter_mappings "[]",
:display "waterfall",
:archived_directly false,
:entity_id "C8V7Dszig-vuqn9TP0igc",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"CREATED_AT\"],\"graph.metrics\":[\"sum\"],\"graph.show_values\":true,\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at #t "2026-02-23T19:38:52.906882Z",
:description "Total revenue last quarter compared to the previous",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"quarter\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"quarter\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"quarter\",\"display_name\":\"Created At: Quarter\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":14,\"nil%\":0.2352941176470588},\"type\":{\"type/Number\":{\"min\":36453.92923470405,\"q1\":65069.208990113075,\"q3\":142628.11468257313,\"max\":150057.1074961184,\"sd\":42907.89243122207,\"avg\":110592.71874078922}}},\"base_type\":\"type/Float\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue per quarter",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T19:38:52.910021Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"lib/type\":\"mbql/query\",\"database\":1,\"stages\":[{\"lib/type\":\"mbql.stage/mbql\",\"aggregation\":[[\"metric\",{\"lib/uuid\":\"217f2201-0f54-48ee-9588-cc3ded68bca3\"},9]],\"breakout\":[[\"field\",{\"lib/uuid\":\"badb9d5d-68c9-459e-8d6e-0b590901d881\",\"base-type\":\"type/DateTime\",\"effective-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"},13]],\"filters\":[[\"in\",{\"lib/uuid\":\"af46c8c5-e5be-4517-8b32-86d3e4e1f64a\"},[\"field\",{\"lib/uuid\":\"87ac4af1-8780-43a7-a527-2d4ff7cf0ef1\",\"base-type\":\"type/Text\",\"effective-type\":\"type/Text\",\"source-field\":14},18],\"Doohickey\",\"Gizmo\",\"Gadget\",\"Widget\"]],\"source-table\":2}]}",
:id 15,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "D4o8cCTOY-SnxoYDRVWcO",
:collection_preview true,
:visualization_settings
"{\"scalar.comparisons\":[{\"id\":\"a8d008d4-d8f1-cbc1-b0ad-f4ab30791b9e\",\"type\":\"previousPeriod\"},{\"id\":\"e7fa0d15-867c-2628-dbea-9f9a41e3ca38\",\"type\":\"periodsAgo\",\"value\":4}],\"column_settings\":{\"[\\\"name\\\",\\\"sum\\\"]\":{\"decimals\":0}}}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Customers that signed up for our monthly subscription",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 7,
:result_metadata
"[{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":7,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"BUTTON_LABEL\",\"lib/original-name\":\"BUTTON_LABEL\",\"lib/breakout?\":false,\"name\":\"BUTTON_LABEL\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"BUTTON_LABEL\",\"lib/original-display-name\":\"Button Label\",\"source\":\"fields\",\"field_ref\":[\"field\",29,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":29,\"lib/desired-column-alias\":\"BUTTON_LABEL\",\"position\":5,\"visibility_type\":\"normal\",\"display_name\":\"Button Label\",\"fingerprint\":{\"global\":{\"distinct-count\":6,\"nil%\":0.8698},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":1.0552}}},\"base_type\":\"type/Text\"},{\"database_type\":\"TIMESTAMP\",\"semantic_type\":null,\"table_id\":7,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"TIMESTAMP\",\"lib/original-name\":\"TIMESTAMP\",\"lib/breakout?\":false,\"unit\":\"month\",\"name\":\"TIMESTAMP\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"TIMESTAMP\",\"lib/original-display-name\":\"Timestamp\",\"source\":\"fields\",\"field_ref\":[\"field\",35,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":35,\"lib/desired-column-alias\":\"TIMESTAMP\",\"position\":3,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"month\",\"display_name\":\"Timestamp: Month\",\"fingerprint\":{\"global\":{\"distinct-count\":8576,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-03-15T00:18:25Z\",\"latest\":\"2022-04-11T20:24:02Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"lib/breakout?\":false,\"name\":\"count\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"count\",\"source\":\"fields\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":160.0,\"q1\":208.5,\"q3\":317.0,\"max\":321.0,\"sd\":74.18164642731156,\"avg\":262.75}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Number of subscriptions",
:last_used_at #t "2026-02-23T12:54:29.140731Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\"=\",[\"field\",\"BUTTON_LABEL\",{\"base-type\":\"type/Text\"}],\"Subscribe\"],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",29,{\"base-type\":\"type/Text\"}],[\"field\",35,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}]],\"source-table\":7}},\"type\":\"query\"}",
:id 16,
:parameter_mappings "[]",
:display "area",
:archived_directly false,
:entity_id "qQ3JGGOxVC8mrOLwxpcR6",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"TIMESTAMP\"],\"graph.metrics\":[\"count\"],\"graph.series_order\":null,\"graph.series_order_dimension\":null,\"graph.show_trendline\":true,\"graph.show_values\":true,\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"scalar.field\":\"count\",\"series_settings\":{\"Subscribe\":{\"color\":\"#7172AD\",\"line.interpolate\":\"linear\",\"title\":\"Subscriptions\"},\"count\":{\"color\":\"#7172AD\"}}}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Compares total revenue this quarter to our goal",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":1,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":145337.23988311572,\"q1\":145337.23988311572,\"q3\":145337.23988311572,\"max\":145337.23988311572,\"sd\":null,\"avg\":145337.23988311572}}},\"base_type\":\"type/Float\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue goal for this quarter",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",9]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],\"current\",\"quarter\"],\"source-table\":2},\"type\":\"query\"}",
:id 17,
:parameter_mappings "[]",
:display "progress",
:archived_directly false,
:entity_id "Ey2qt4I-wcg1E0846iUQS",
:collection_preview true,
:visualization_settings
"{\"column_settings\":{\"[\\\"name\\\",\\\"sum\\\"]\":{\"decimals\":0}},\"progress.goal\":250000}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description
"Shows a distribution of orders broken down by product category across our customers' individual age values",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/Decimal\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/Decimal\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"display_name\":\"Products → Category\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",18,{\"base-type\":\"type/Text\",\"join-alias\":\"Products\"}],\"fk_target_field_id\":null,\"id\":18,\"name\":\"CATEGORY\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Product category orders per age",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],[\"field\",18,{\"base-type\":\"type/Text\",\"join-alias\":\"Products\"}]],\"joins\":[{\"alias\":\"Products\",\"condition\":[\"=\",[\"field\",\"PRODUCT_ID\",{\"base-type\":\"type/Integer\"}],[\"field\",8,{\"base-type\":\"type/BigInteger\",\"join-alias\":\"Products\"}]],\"source-table\":3,\"strategy\":\"left-join\"}],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 18,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "byM0vLfOiM1zBI_t1MUcO",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\",\"CATEGORY\"],\"graph.metrics\":[\"count\"],\"graph.show_values\":true,\"graph.x_axis.scale\":\"linear\",\"series_settings\":{\"Doohickey\":{\"color\":\"#7172AD\"},\"Gadget\":{\"color\":\"#999AC4\"},\"Gizmo\":{\"color\":\"#C7EAEA\"},\"Widget\":{\"color\":\"#227FD2\"}},\"stackable.stack_type\":\"normalized\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Canonical metric for number of orders placed",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Month\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"month\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Number of Orders",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "metric",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-3,\"year\",{\"include-current\":true}],\"source-table\":2},\"type\":\"query\"}",
:id 19,
:parameter_mappings "[]",
:display "line",
:archived_directly false,
:entity_id "8EdazRgPwfxdiltp7NCjS",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"CREATED_AT\"],\"graph.metrics\":[\"count\"]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Breaks down the overall performance of each of the product categories",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":3799.0,\"q1\":4212.5,\"q3\":4795.5,\"max\":4851.0,\"sd\":478.8924722732651,\"avg\":4504.0}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Total orders by product category",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",19]],\"breakout\":[[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"source-table\":2},\"type\":\"query\"}",
:id 20,
:parameter_mappings "[]",
:display "pie",
:archived_directly false,
:entity_id "ShsD1PjGTlFIvzm5FM9qC",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"pie.decimal_places\":0,\"pie.percent_visibility\":\"both\",\"pie.rows\":[{\"color\":\"#7172AD\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Doohickey\",\"name\":\"Doohickey\",\"originalName\":\"Doohickey\"},{\"color\":\"#A989C5\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Gadget\",\"name\":\"Gadget\",\"originalName\":\"Gadget\"},{\"color\":\"#C7EAEA\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Gizmo\",\"name\":\"Gizmo\",\"originalName\":\"Gizmo\"},{\"color\":\"#227FD2\",\"defaultColor\":false,\"enabled\":true,\"hidden\":false,\"isOther\":false,\"key\":\"Widget\",\"name\":\"Widget\",\"originalName\":\"Widget\"}],\"pie.show_labels\":false,\"pie.sort_rows\":false}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "An ordered list of our most successful products",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The name of the product as it should be displayed to customers.\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Title\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"TITLE\",\"lib/original-name\":\"TITLE\",\"lib/breakout?\":false,\"name\":\"TITLE\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"PRODUCTS__via__PRODUCT_ID__TITLE\",\"lib/original-display-name\":\"Title\",\"lib/original-fk-field-id\":14,\"source\":\"fields\",\"field_ref\":[\"field\",17,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":17,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__TITLE\",\"position\":2,\"visibility_type\":\"normal\",\"display_name\":\"Product → Title\",\"fingerprint\":{\"global\":{\"distinct-count\":199,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":21.495}}},\"base_type\":\"type/Text\"},{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":false,\"name\":\"CATEGORY\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"lib/original-display-name\":\"Category\",\"lib/original-fk-field-id\":14,\"source\":\"fields\",\"field_ref\":[\"field\",18,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"lib/breakout?\":false,\"name\":\"count\",\"lib/source\":\"source/previous-stage\",\"lib/source-column-alias\":\"count\",\"source\":\"fields\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/BigInteger\"}],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":7,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":110.0,\"q1\":112.74341649025257,\"q3\":118.25,\"max\":120.0,\"sd\":3.5039660069381062,\"avg\":115.55555555555556}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Best selling products",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\">=\",[\"field\",\"count\",{\"base-type\":\"type/Integer\"}],110],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",17,{\"base-type\":\"type/Text\",\"source-field\":14}],[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}]],\"filter\":[\"!=\",[\"field\",17,{\"base-type\":\"type/Text\",\"source-field\":14}],\"Incredible Aluminum Knife\"],\"order-by\":[[\"desc\",[\"aggregation\",0]]],\"source-table\":2}},\"type\":\"query\"}",
:id 21,
:parameter_mappings "[]",
:display "row",
:archived_directly false,
:entity_id "S-hEu1jZ2-822qvBQ1EiT",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"TITLE\"],\"graph.metrics\":[\"count\"],\"graph.series_order\":null,\"graph.series_order_dimension\":null,\"graph.show_values\":true,\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"series_settings\":{\"count\":{\"color\":\"#999AC4\"}},\"stackable.stack_type\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Indicates the average customer review of our products",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 3,
:result_metadata
"[{\"database_type\":\"DECFLOAT\",\"semantic_type\":\"type/Score\",\"lib/deduplicated-name\":\"avg\",\"lib/original-name\":\"avg\",\"name\":\"avg\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"avg\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"avg\",\"display_name\":\"Average of Rating\",\"fingerprint\":{\"global\":{\"distinct-count\":1,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":3.4715,\"q1\":3.4715,\"q3\":3.4715,\"max\":3.4715,\"sd\":null,\"avg\":3.4715}}},\"base_type\":\"type/Float\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Average product rating",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"avg\",[\"field\",16,{\"base-type\":\"type/Float\"}]]],\"source-table\":3},\"type\":\"query\"}",
:id 22,
:parameter_mappings "[]",
:display "gauge",
:archived_directly false,
:entity_id "fKu0z-vEC1WwVv1Lu95jD",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"gauge.segments\":[{\"color\":\"#ED6E6E\",\"label\":\"\",\"max\":1,\"min\":0},{\"color\":\"#F2A86F\",\"label\":\"\",\"max\":2,\"min\":1},{\"color\":\"#F9D45C\",\"label\":\"\",\"max\":3,\"min\":2},{\"color\":\"#A7D07C\",\"label\":\"\",\"max\":4,\"min\":3},{\"color\":\"#689636\",\"label\":\"\",\"max\":5,\"min\":4}]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "The most recent subscription in our database",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 6,
:result_metadata
"[{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/PK\",\"table_id\":6,\"lib/deduplicated-name\":\"ID\",\"lib/original-name\":\"ID\",\"name\":\"ID\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"ID\",\"lib/original-display-name\":\"ID\",\"source\":\"fields\",\"field_ref\":[\"field\",24,null],\"effective_type\":\"type/BigInteger\",\"active\":true,\"id\":24,\"lib/desired-column-alias\":\"ID\",\"position\":0,\"visibility_type\":\"normal\",\"display_name\":\"ID\",\"fingerprint\":null,\"base_type\":\"type/BigInteger\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Name\",\"table_id\":6,\"lib/deduplicated-name\":\"FIRST_NAME\",\"lib/original-name\":\"FIRST_NAME\",\"name\":\"FIRST_NAME\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"FIRST_NAME\",\"lib/original-display-name\":\"First Name\",\"source\":\"fields\",\"field_ref\":[\"field\",37,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":37,\"lib/desired-column-alias\":\"FIRST_NAME\",\"position\":2,\"visibility_type\":\"normal\",\"display_name\":\"First Name\",\"fingerprint\":{\"global\":{\"distinct-count\":1687,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.001603206412825651,\"average-length\":5.997595190380761}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Name\",\"table_id\":6,\"lib/deduplicated-name\":\"LAST_NAME\",\"lib/original-name\":\"LAST_NAME\",\"name\":\"LAST_NAME\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"LAST_NAME\",\"lib/original-display-name\":\"Last Name\",\"source\":\"fields\",\"field_ref\":[\"field\",36,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":36,\"lib/desired-column-alias\":\"LAST_NAME\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Last Name\",\"fingerprint\":{\"global\":{\"distinct-count\":473,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.536673346693386}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":6,\"lib/deduplicated-name\":\"PLAN\",\"lib/original-name\":\"PLAN\",\"name\":\"PLAN\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"PLAN\",\"lib/original-display-name\":\"Plan\",\"source\":\"fields\",\"field_ref\":[\"field\",43,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":43,\"lib/desired-column-alias\":\"PLAN\",\"position\":4,\"visibility_type\":\"normal\",\"display_name\":\"Plan\",\"fingerprint\":{\"global\":{\"distinct-count\":3,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":5.1062124248497}}},\"base_type\":\"type/Text\"},{\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Source\",\"table_id\":6,\"lib/deduplicated-name\":\"SOURCE\",\"lib/original-name\":\"SOURCE\",\"name\":\"SOURCE\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"SOURCE\",\"lib/original-display-name\":\"Source\",\"source\":\"fields\",\"field_ref\":[\"field\",41,null],\"effective_type\":\"type/Text\",\"active\":true,\"id\":41,\"lib/desired-column-alias\":\"SOURCE\",\"position\":5,\"visibility_type\":\"normal\",\"display_name\":\"Source\",\"fingerprint\":{\"global\":{\"distinct-count\":5,\"nil%\":0.3346693386773547},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":4.4705410821643286}}},\"base_type\":\"type/Text\"},{\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":6,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"fields\",\"field_ref\":[\"field\",31,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":31,\"lib/desired-column-alias\":\"CREATED_AT\",\"position\":7,\"visibility_type\":\"normal\",\"display_name\":\"Created At\",\"fingerprint\":{\"global\":{\"distinct-count\":2495,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2020-09-15T16:11:50Z\",\"latest\":\"2031-10-10T19:14:48Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"TIMESTAMP\",\"semantic_type\":null,\"table_id\":6,\"lib/deduplicated-name\":\"TRIAL_ENDS_AT\",\"lib/original-name\":\"TRIAL_ENDS_AT\",\"name\":\"TRIAL_ENDS_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"TRIAL_ENDS_AT\",\"lib/original-display-name\":\"Trial Ends At\",\"source\":\"fields\",\"field_ref\":[\"field\",40,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":40,\"lib/desired-column-alias\":\"TRIAL_ENDS_AT\",\"position\":8,\"visibility_type\":\"normal\",\"display_name\":\"Trial Ends At\",\"fingerprint\":{\"global\":{\"distinct-count\":1712,\"nil%\":0.001202404809619238},\"type\":{\"type/DateTime\":{\"earliest\":\"2020-09-30T12:00:00Z\",\"latest\":\"2031-10-25T12:00:00Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CancelationTimestamp\",\"table_id\":6,\"lib/deduplicated-name\":\"CANCELED_AT\",\"lib/original-name\":\"CANCELED_AT\",\"name\":\"CANCELED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CANCELED_AT\",\"lib/original-display-name\":\"Canceled At\",\"source\":\"fields\",\"field_ref\":[\"field\",39,null],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":39,\"lib/desired-column-alias\":\"CANCELED_AT\",\"position\":9,\"visibility_type\":\"normal\",\"display_name\":\"Canceled At\",\"fingerprint\":{\"global\":{\"distinct-count\":2021,\"nil%\":0.1859719438877756},\"type\":{\"type/DateTime\":{\"earliest\":\"2020-10-01T15:43:40Z\",\"latest\":\"2032-06-03T14:01:15Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BOOLEAN\",\"semantic_type\":null,\"table_id\":6,\"lib/deduplicated-name\":\"TRIAL_CONVERTED\",\"lib/original-name\":\"TRIAL_CONVERTED\",\"name\":\"TRIAL_CONVERTED\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"TRIAL_CONVERTED\",\"lib/original-display-name\":\"Trial Converted\",\"source\":\"fields\",\"field_ref\":[\"field\",38,null],\"effective_type\":\"type/Boolean\",\"active\":true,\"id\":38,\"lib/desired-column-alias\":\"TRIAL_CONVERTED\",\"position\":10,\"visibility_type\":\"normal\",\"display_name\":\"Trial Converted\",\"fingerprint\":{\"global\":{\"distinct-count\":2,\"nil%\":0.0}},\"base_type\":\"type/Boolean\"},{\"database_type\":\"BOOLEAN\",\"semantic_type\":null,\"table_id\":6,\"lib/deduplicated-name\":\"ACTIVE_SUBSCRIPTION\",\"lib/original-name\":\"ACTIVE_SUBSCRIPTION\",\"name\":\"ACTIVE_SUBSCRIPTION\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"ACTIVE_SUBSCRIPTION\",\"lib/original-display-name\":\"Active Subscription\",\"source\":\"fields\",\"field_ref\":[\"field\",42,null],\"effective_type\":\"type/Boolean\",\"active\":true,\"id\":42,\"lib/desired-column-alias\":\"ACTIVE_SUBSCRIPTION\",\"position\":11,\"visibility_type\":\"normal\",\"display_name\":\"Active Subscription\",\"fingerprint\":{\"global\":{\"distinct-count\":2,\"nil%\":0.0}},\"base_type\":\"type/Boolean\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Most recent subscription",
:last_used_at #t "2026-02-23T18:56:22.895226Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"fields\":[[\"field\",24,{\"base-type\":\"type/BigInteger\"}],[\"field\",37,{\"base-type\":\"type/Text\"}],[\"field\",36,{\"base-type\":\"type/Text\"}],[\"field\",43,{\"base-type\":\"type/Text\"}],[\"field\",41,{\"base-type\":\"type/Text\"}],[\"field\",31,{\"base-type\":\"type/DateTime\"}],[\"field\",40,{\"base-type\":\"type/DateTime\"}],[\"field\",39,{\"base-type\":\"type/DateTime\"}],[\"field\",38,{\"base-type\":\"type/Boolean\"}],[\"field\",42,{\"base-type\":\"type/Boolean\"}]],\"filter\":[\"time-interval\",[\"field\",31,{\"base-type\":\"type/DateTime\"}],-12,\"month\"],\"order-by\":[[\"desc\",[\"field\",31,{\"base-type\":\"type/DateTime\"}]]],\"source-table\":6},\"type\":\"query\"}",
:id 23,
:parameter_mappings "[]",
:display "object",
:archived_directly false,
:entity_id "AXDOILGSNqoWoxV1NuvTt",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"table.columns\":[{\"enabled\":true,\"name\":\"ID\"},{\"enabled\":true,\"name\":\"FIRST_NAME\"},{\"enabled\":true,\"name\":\"LAST_NAME\"},{\"enabled\":true,\"name\":\"PLAN\"},{\"enabled\":false,\"name\":\"SOURCE\"},{\"enabled\":true,\"name\":\"CREATED_AT\"},{\"enabled\":true,\"name\":\"TRIAL_ENDS_AT\"},{\"enabled\":true,\"name\":\"CANCELED_AT\"},{\"enabled\":false,\"name\":\"TRIAL_CONVERTED\"},{\"enabled\":false,\"name\":\"ACTIVE_SUBSCRIPTION\"}]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Compares the orders of each category quarter over quarter",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"quarter\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"quarter\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"quarter\",\"display_name\":\"Created At: Quarter\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":38,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":73.0,\"q1\":332.5,\"q3\":429.5,\"max\":467.0,\"sd\":105.26609749606602,\"avg\":360.15}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Orders by product category",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"metric\",19]],\"breakout\":[[\"field\",18,{\"base-type\":\"type/Text\",\"source-field\":14}],[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\",\"original-temporal-unit\":\"month\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-2,\"year\",{\"include-current\":true}],\"source-table\":2},\"type\":\"query\"}",
:id 24,
:parameter_mappings "[]",
:display "line",
:archived_directly false,
:entity_id "kgAiQ87dLKJmTnOaTeVsc",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"CREATED_AT\",\"CATEGORY\"],\"graph.goal_value\":500,\"graph.label_value_formatting\":\"compact\",\"graph.metrics\":[\"count\"],\"graph.show_goal\":true,\"graph.show_trendline\":false,\"graph.show_values\":true,\"graph.x_axis.title_text\":\"\",\"graph.y_axis.title_text\":\"\",\"series_settings\":{\"Doohickey\":{\"color\":\"#7172AD\",\"display\":\"area\",\"line.interpolate\":\"cardinal\",\"line.size\":\"M\",\"line.style\":\"solid\"},\"Gadget\":{\"color\":\"#A989C5\",\"line.size\":\"M\"},\"Gizmo\":{\"color\":\"#C7EAEA\",\"line.size\":\"M\",\"line.style\":\"solid\"},\"Widget\":{\"color\":\"#227FD2\",\"line.size\":\"M\"}}}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "More complete look at all recent subscriptions",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 6,
:result_metadata
"[{\"base_type\":\"type/BigInteger\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"ID\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",24,{\"base-type\":\"type/BigInteger\"}],\"fk_target_field_id\":null,\"id\":24,\"name\":\"ID\",\"semantic_type\":\"type/PK\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"First Name\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",37,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":37,\"name\":\"FIRST_NAME\",\"semantic_type\":\"type/Name\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Last Name\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",36,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":36,\"name\":\"LAST_NAME\",\"semantic_type\":\"type/Name\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Plan\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",43,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":43,\"name\":\"PLAN\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Source\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",41,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":41,\"name\":\"SOURCE\",\"semantic_type\":\"type/Source\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Created At\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",31,{\"base-type\":\"type/DateTime\"}],\"fk_target_field_id\":null,\"id\":31,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Trial Ends At\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",40,{\"base-type\":\"type/DateTime\"}],\"fk_target_field_id\":null,\"id\":40,\"name\":\"TRIAL_ENDS_AT\",\"semantic_type\":null,\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Canceled At\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",39,{\"base-type\":\"type/DateTime\"}],\"fk_target_field_id\":null,\"id\":39,\"name\":\"CANCELED_AT\",\"semantic_type\":\"type/CancelationTimestamp\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Boolean\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Trial Converted\",\"effective_type\":\"type/Boolean\",\"field_ref\":[\"field\",38,{\"base-type\":\"type/Boolean\"}],\"fk_target_field_id\":null,\"id\":38,\"name\":\"TRIAL_CONVERTED\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Boolean\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Active Subscription\",\"effective_type\":\"type/Boolean\",\"field_ref\":[\"field\",42,{\"base-type\":\"type/Boolean\"}],\"fk_target_field_id\":null,\"id\":42,\"name\":\"ACTIVE_SUBSCRIPTION\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "All subscriptions in table view",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"fields\":[[\"field\",24,{\"base-type\":\"type/BigInteger\"}],[\"field\",37,{\"base-type\":\"type/Text\"}],[\"field\",36,{\"base-type\":\"type/Text\"}],[\"field\",43,{\"base-type\":\"type/Text\"}],[\"field\",41,{\"base-type\":\"type/Text\"}],[\"field\",31,{\"base-type\":\"type/DateTime\"}],[\"field\",40,{\"base-type\":\"type/DateTime\"}],[\"field\",39,{\"base-type\":\"type/DateTime\"}],[\"field\",38,{\"base-type\":\"type/Boolean\"}],[\"field\",42,{\"base-type\":\"type/Boolean\"}]],\"filter\":[\"time-interval\",[\"field\",31,{\"base-type\":\"type/DateTime\"}],-12,\"month\"],\"order-by\":[[\"desc\",[\"field\",31,{\"base-type\":\"type/DateTime\"}]]],\"source-table\":6},\"type\":\"query\"}",
:id 25,
:parameter_mappings "[]",
:display "table",
:archived_directly false,
:entity_id "ucI5e9_FdTQF-1i7RdtIX",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"table.cell_column\":\"ACTIVE_SUBSCRIPTION\",\"table.columns\":[{\"enabled\":true,\"name\":\"ID\"},{\"enabled\":true,\"name\":\"FIRST_NAME\"},{\"enabled\":true,\"name\":\"LAST_NAME\"},{\"enabled\":true,\"name\":\"PLAN\"},{\"enabled\":false,\"name\":\"SOURCE\"},{\"enabled\":true,\"name\":\"CREATED_AT\"},{\"enabled\":true,\"name\":\"TRIAL_ENDS_AT\"},{\"enabled\":true,\"name\":\"CANCELED_AT\"},{\"enabled\":false,\"name\":\"TRIAL_CONVERTED\"},{\"enabled\":false,\"name\":\"ACTIVE_SUBSCRIPTION\"}],\"table.pivot_column\":\"CANCELED_AT\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Compares the total number of orders placed for this product this month with the previous period",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Month\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"month\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Sum of Quantity\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Quantity\",\"settings\":{\"show_mini_bar\":false}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Heavy-Duty Silk Chair trend",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",2,{\"base-type\":\"type/Integer\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}]],\"filter\":[\"and\",[\"between\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],\"2024-01-01\",\"2027-01-23\"],[\"=\",[\"field\",14,{\"base-type\":\"type/Integer\"}],86]],\"source-table\":2},\"type\":\"query\"}",
:id 26,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "fdkSuB8zWEbjEq_vWMaI-",
:collection_preview true,
:visualization_settings "{\"column_settings\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Total sum of products sold last quarter compared to the previous",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Quarter\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"quarter\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Sum of Quantity\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Quantity\",\"settings\":{\"show_mini_bar\":false}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Quantity sold per quarter",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",2,{\"base-type\":\"type/Integer\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-2,\"quarter\",{\"include-current\":false}],\"source-table\":2},\"type\":\"query\"}",
:id 27,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "A5pNCrrWtf2bVka2vXVLx",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"scalar.compact_primary_number\":true,\"scalar.field\":\"sum\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows the revenue distributed by age group",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/Decimal\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/Decimal\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Float\",\"display_name\":\"Sum of Total\",\"effective_type\":\"type/Float\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Currency\",\"settings\":{\"currency\":\"USD\"}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue per age group",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",\"TOTAL\",{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\",\"binning\":{\"strategy\":\"num-bins\",\"num-bins\":10}}]],\"filter\":[\"between\",[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],20,70],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 28,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "g7G9X1p0na--gwNCUL75j",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\"],\"graph.metrics\":[\"sum\"],\"graph.show_values\":true}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Compares the total number of orders placed for this product this month with the previous period",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Month\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"month\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Sum of Quantity\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Quantity\",\"settings\":{\"show_mini_bar\":false}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Enormous Wool Car trend",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",2,{\"base-type\":\"type/Integer\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}]],\"filter\":[\"and\",[\"between\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],\"2024-01-01\",\"2027-01-23\"],[\"=\",[\"field\",14,{\"base-type\":\"type/Integer\"}],17]],\"source-table\":2},\"type\":\"query\"}",
:id 29,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "HSVx57QxslVTGbo1_XS4G",
:collection_preview true,
:visualization_settings "{\"column_settings\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Unique customer email addresses last quarter compared to the previous",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Quarter\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",\"CREATED_AT\",{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"quarter\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Distinct values of Customer Email\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\",\"settings\":{\"link_text\":\"\"}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Unique customers per month",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"distinct\",[\"field\",\"EMAIL\",{\"base-type\":\"type/Text\"}]]],\"breakout\":[[\"field\",\"CREATED_AT\",{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}]],\"filter\":[\"time-interval\",[\"field\",\"CREATED_AT\",{\"base-type\":\"type/DateTime\"}],-2,\"quarter\"],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 30,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "leO-OHTwIMltfpcLLOJxj",
:collection_preview true,
:visualization_settings "{\"column_settings\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Flow from viewing our website (empty) to checkout and subscribe",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 7,
:result_metadata
"[{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":null,\"display_name\":\"Button Label\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",29,{\"base-type\":\"type/Text\"}],\"fk_target_field_id\":null,\"id\":29,\"name\":\"BUTTON_LABEL\",\"semantic_type\":\"type/Category\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",\"count\",{\"base-type\":\"type/Integer\"}],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Checkout funnel - Modified",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"filter\":[\"not-empty\",[\"field\",\"BUTTON_LABEL\",{\"base-type\":\"type/Text\"}]],\"source-query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",29,{\"base-type\":\"type/Text\"}]],\"source-table\":7}},\"type\":\"query\"}",
:id 31,
:parameter_mappings "[]",
:display "funnel",
:archived_directly false,
:entity_id "dzFHc6awtpZCSn9-wscNQ",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"funnel.order_dimension\":\"BUTTON_LABEL\",\"funnel.rows\":[{\"enabled\":true,\"key\":\"Create Item\",\"name\":\"Create Item\"},{\"enabled\":true,\"key\":\"Invite\",\"name\":\"Invite\"},{\"enabled\":true,\"key\":\"Subscribe\",\"name\":\"Subscribe\"},{\"enabled\":true,\"key\":\"Signup\",\"name\":\"Signup\"},{\"enabled\":true,\"key\":\"Checkout\",\"name\":\"Checkout\"}]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description nil,
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 1,
:result_metadata
"[{\"base_type\":\"type/BigInteger\",\"coercion_strategy\":null,\"description\":\"A unique identifier given to each user.\",\"display_name\":\"ID\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",4,null],\"fk_target_field_id\":null,\"id\":4,\"name\":\"ID\",\"semantic_type\":\"type/PK\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The street address of the account’s billing address\",\"display_name\":\"Address\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",51,null],\"fk_target_field_id\":null,\"id\":51,\"name\":\"ADDRESS\",\"semantic_type\":null,\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The contact email for the account.\",\"display_name\":\"Email\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",7,null],\"fk_target_field_id\":null,\"id\":7,\"name\":\"EMAIL\",\"semantic_type\":\"type/Email\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The name of the user who owns an account\",\"display_name\":\"Name\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",48,null],\"fk_target_field_id\":null,\"id\":48,\"name\":\"NAME\",\"semantic_type\":\"type/Name\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The city of the account’s billing address\",\"display_name\":\"City\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",53,null],\"fk_target_field_id\":null,\"id\":53,\"name\":\"CITY\",\"semantic_type\":\"type/City\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"This is the longitude of the user on sign-up. It might be updated in the future to the last seen location.\",\"display_name\":\"Longitude\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",58,null],\"fk_target_field_id\":null,\"id\":58,\"name\":\"LONGITUDE\",\"semantic_type\":\"type/Longitude\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The state or province of the account’s billing address\",\"display_name\":\"State\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",1,null],\"fk_target_field_id\":null,\"id\":1,\"name\":\"STATE\",\"semantic_type\":\"type/State\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The channel through which we acquired this user. Valid values include: Affiliate, Facebook, Google, Organic and Twitter\",\"display_name\":\"Source\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",30,null],\"fk_target_field_id\":null,\"id\":30,\"name\":\"SOURCE\",\"semantic_type\":\"type/Source\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Date\",\"coercion_strategy\":null,\"description\":\"The date of birth of the user\",\"display_name\":\"Birth Date\",\"effective_type\":\"type/Date\",\"field_ref\":[\"field\",12,null],\"fk_target_field_id\":null,\"id\":12,\"name\":\"BIRTH_DATE\",\"semantic_type\":\"type/Birthdate\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The postal code of the account’s billing address\",\"display_name\":\"Zip\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",61,null],\"fk_target_field_id\":null,\"id\":61,\"name\":\"ZIP\",\"semantic_type\":\"type/ZipCode\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"coercion_strategy\":null,\"description\":\"This is the latitude of the user on sign-up. It might be updated in the future to the last seen location.\",\"display_name\":\"Latitude\",\"effective_type\":\"type/Float\",\"field_ref\":[\"field\",52,null],\"fk_target_field_id\":null,\"id\":52,\"name\":\"LATITUDE\",\"semantic_type\":\"type/Latitude\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date the user record was created. Also referred to as the user’s \\\"join date\\\"\",\"display_name\":\"Created At\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",50,null],\"fk_target_field_id\":null,\"id\":50,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Age\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"expression\",\"Age\"],\"name\":\"Age\",\"semantic_type\":null}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "People with age",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"expressions\":{\"Age\":[\"datetime-diff\",[\"field\",12,{\"base-type\":\"type/Date\"}],[\"now\"],\"year\"]},\"source-table\":1},\"type\":\"query\"}",
:id 32,
:parameter_mappings "[]",
:display "table",
:archived_directly false,
:entity_id "c5m4bxKyi7GEa1sML-wpu",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"table.cell_column\":\"LONGITUDE\",\"table.pivot_column\":\"SOURCE\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows a distribution of revenue per individual age values",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/BigInteger\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Float\",\"display_name\":\"Sum of Total\",\"effective_type\":\"type/Float\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Currency\",\"settings\":{\"currency\":\"USD\"}}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Revenue per individual age",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",\"TOTAL\",{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}]],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 33,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "T9OjH7_py-tNsyPb4O8yC",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\"],\"graph.metrics\":[\"sum\"],\"graph.show_values\":true}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Total amount of discounts last quarter compared to the previous",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/DateTime\",\"coercion_strategy\":null,\"description\":\"The date and time an order was submitted.\",\"display_name\":\"Created At: Quarter\",\"effective_type\":\"type/DateTime\",\"field_ref\":[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}],\"fk_target_field_id\":null,\"id\":13,\"name\":\"CREATED_AT\",\"semantic_type\":\"type/CreationTimestamp\",\"settings\":{\"time_enabled\":\"milliseconds\"},\"unit\":\"quarter\",\"visibility_type\":\"normal\"},{\"base_type\":\"type/Float\",\"display_name\":\"Sum of Discount\",\"effective_type\":\"type/Float\",\"field_ref\":[\"aggregation\",0],\"name\":\"sum\",\"semantic_type\":\"type/Discount\",\"settings\":null}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Discounts given per quarter",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",3,{\"base-type\":\"type/Float\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"quarter\"}]],\"filter\":[\"time-interval\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],-2,\"quarter\",{\"include-current\":false}],\"source-table\":2},\"type\":\"query\"}",
:id 34,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "IEp2LZKY_aJMpchBacdjP",
:collection_preview true,
:visualization_settings "{\"column_settings\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows a distribution of orders broken down by source across our customers' individual age values",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/BigInteger\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The channel through which we acquired this user. Valid values include: Affiliate, Facebook, Google, Organic and Twitter\",\"display_name\":\"User → Source\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",30,{\"base-type\":\"type/Text\",\"source-field\":11}],\"fk_target_field_id\":null,\"id\":30,\"name\":\"SOURCE\",\"semantic_type\":\"type/Source\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Orders by source per individual age",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],[\"field\",30,{\"base-type\":\"type/Text\",\"source-field\":11}]],\"joins\":[{\"alias\":\"Products\",\"condition\":[\"=\",[\"field\",\"PRODUCT_ID\",{\"base-type\":\"type/Integer\"}],[\"field\",8,{\"base-type\":\"type/BigInteger\",\"join-alias\":\"Products\"}]],\"source-table\":3,\"strategy\":\"left-join\"}],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 35,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "8MovkFBA00WFOq2v5BzfB",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\",\"SOURCE\"],\"graph.metrics\":[\"count\"],\"graph.show_values\":true,\"graph.x_axis.scale\":\"linear\",\"stackable.stack_type\":\"normalized\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Shows a distribution of orders broken down by source across our customers' age groups",
:archived false,
:collection_position nil,
:source_card_id 1,
:table_id 2,
:result_metadata
"[{\"base_type\":\"type/Decimal\",\"description\":\"Age of the customer in years.\",\"display_name\":\"Age\",\"effective_type\":\"type/Decimal\",\"field_ref\":[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],\"name\":\"Age\",\"semantic_type\":\"type/Quantity\"},{\"base_type\":\"type/Text\",\"coercion_strategy\":null,\"description\":\"The channel through which we acquired this user. Valid values include: Affiliate, Facebook, Google, Organic and Twitter\",\"display_name\":\"User → Source\",\"effective_type\":\"type/Text\",\"field_ref\":[\"field\",30,{\"base-type\":\"type/Text\",\"source-field\":11}],\"fk_target_field_id\":null,\"id\":30,\"name\":\"SOURCE\",\"semantic_type\":\"type/Source\",\"settings\":null,\"visibility_type\":\"normal\"},{\"base_type\":\"type/BigInteger\",\"display_name\":\"Count\",\"effective_type\":\"type/BigInteger\",\"field_ref\":[\"aggregation\",0],\"name\":\"count\",\"semantic_type\":\"type/Quantity\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Orders by source per age group",
:last_used_at #t "2026-02-23T11:14:53.782096Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"count\"]],\"breakout\":[[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\",\"binning\":{\"strategy\":\"num-bins\",\"num-bins\":10}}],[\"field\",30,{\"base-type\":\"type/Text\",\"source-field\":11}]],\"filter\":[\"between\",[\"field\",\"Age\",{\"base-type\":\"type/BigInteger\"}],20,70],\"joins\":[{\"alias\":\"Products\",\"condition\":[\"=\",[\"field\",\"PRODUCT_ID\",{\"base-type\":\"type/Integer\"}],[\"field\",8,{\"base-type\":\"type/BigInteger\",\"join-alias\":\"Products\"}]],\"source-table\":3,\"strategy\":\"left-join\"}],\"source-table\":\"card__1\"},\"type\":\"query\"}",
:id 36,
:parameter_mappings "[]",
:display "bar",
:archived_directly false,
:entity_id "yBoV-iHmFUrY9xqB0v9Pg",
:collection_preview true,
:visualization_settings
"{\"column_settings\":null,\"graph.dimensions\":[\"Age\",\"SOURCE\"],\"graph.metrics\":[\"count\"],\"graph.show_values\":true,\"graph.x_axis.scale\":\"linear\",\"stackable.stack_type\":\"stacked\"}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at nil,
:description "Compares the total number of orders placed for this product this month with the previous period",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"month\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"month\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"month\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"month\",\"display_name\":\"Created At: Month\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Quantity\",\"fingerprint\":{\"global\":{\"distinct-count\":7,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":1.0,\"q1\":3.25,\"q3\":6.0,\"max\":74.0,\"sd\":22.086949389477336,\"avg\":11.5}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Aerodynamic Copper Knife trend",
:last_used_at #t "2026-02-23T12:38:01.714283Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T11:14:53.782096Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"database\":1,\"query\":{\"aggregation\":[[\"sum\",[\"field\",2,{\"base-type\":\"type/Integer\"}]]],\"breakout\":[[\"field\",13,{\"base-type\":\"type/DateTime\",\"temporal-unit\":\"month\"}]],\"filter\":[\"and\",[\"between\",[\"field\",13,{\"base-type\":\"type/DateTime\"}],\"2024-01-01\",\"2027-01-23\"],[\"=\",[\"field\",14,{\"base-type\":\"type/Integer\"}],165]],\"source-table\":2},\"type\":\"query\"}",
:id 37,
:parameter_mappings "[]",
:display "smartscalar",
:archived_directly false,
:entity_id "BQAQ6YNiUIMfmAPLpSKQW",
:collection_preview true,
:visualization_settings "{\"column_settings\":null}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T11:14:53.782096Z",
:public_uuid nil}
{:cache_invalidated_at #t "2026-02-23T12:44:25.503824Z",
:description
"Order total distribution by category (median, IQR, outliers) to see which categories tend to drive bigger revenue.",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The type of product, valid values include: Doohicky, Gadget, Gizmo and Widget\",\"database_type\":\"CHARACTER VARYING\",\"semantic_type\":\"type/Category\",\"table_id\":3,\"qp/implicit-field?\":true,\"lib/deduplicated-name\":\"CATEGORY\",\"lib/original-name\":\"CATEGORY\",\"lib/breakout?\":true,\"name\":\"CATEGORY\",\"lib/source\":\"source/implicitly-joinable\",\"lib/source-column-alias\":\"CATEGORY\",\"lib/original-display-name\":\"Category\",\"source\":\"breakout\",\"fk_field_id\":14,\"field_ref\":[\"field\",18,{\"source-field\":14}],\"effective_type\":\"type/Text\",\"active\":true,\"id\":18,\"lib/desired-column-alias\":\"PRODUCTS__via__PRODUCT_ID__CATEGORY\",\"position\":3,\"visibility_type\":\"normal\",\"display_name\":\"Product → Category\",\"fingerprint\":{\"global\":{\"distinct-count\":4,\"nil%\":0.0},\"type\":{\"type/Text\":{\"percent-json\":0.0,\"percent-url\":0.0,\"percent-email\":0.0,\"percent-state\":0.0,\"average-length\":6.375}}},\"base_type\":\"type/Text\"},{\"description\":\"This is a unique ID for the product. It is also called the “Invoice number” or “Confirmation number” in customer facing emails and screens.\",\"database_type\":\"BIGINT\",\"semantic_type\":\"type/PK\",\"table_id\":2,\"lib/deduplicated-name\":\"ID\",\"lib/original-name\":\"ID\",\"lib/breakout?\":true,\"name\":\"ID\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"ID\",\"lib/original-display-name\":\"ID\",\"source\":\"breakout\",\"field_ref\":[\"field\",9,null],\"effective_type\":\"type/BigInteger\",\"active\":true,\"id\":9,\"lib/desired-column-alias\":\"ID\",\"position\":0,\"visibility_type\":\"normal\",\"display_name\":\"ID\",\"fingerprint\":null,\"base_type\":\"type/BigInteger\"},{\"database_type\":\"DECFLOAT\",\"semantic_type\":null,\"lib/deduplicated-name\":\"sum\",\"lib/original-name\":\"sum\",\"name\":\"sum\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"sum\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/Float\",\"lib/desired-column-alias\":\"sum\",\"display_name\":\"Sum of Total\",\"fingerprint\":{\"global\":{\"distinct-count\":2768,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":17.37274156138626,\"q1\":59.11078403152785,\"q3\":118.53731448130873,\"max\":158.6090052655229,\"sd\":34.19707462997857,\"avg\":87.87381771617375}}},\"base_type\":\"type/Float\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Order value distribution by category",
:last_used_at #t "2026-02-23T19:44:12.384034Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T12:44:25.507915Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"lib/type\":\"mbql/query\",\"database\":1,\"stages\":[{\"lib/type\":\"mbql.stage/mbql\",\"aggregation\":[[\"sum\",{\"lib/uuid\":\"97e6db75-ac92-4530-83ef-d1be55b5472b\"},[\"field\",{\"effective-type\":\"type/Float\",\"base-type\":\"type/Float\",\"lib/uuid\":\"c701b004-99b5-4d69-b8c4-103e7471cb93\"},5]]],\"breakout\":[[\"field\",{\"lib/uuid\":\"b1f85891-fff0-49da-9658-8dbd21d2586c\",\"base-type\":\"type/Text\",\"effective-type\":\"type/Text\",\"source-field\":14},18],[\"field\",{\"effective-type\":\"type/BigInteger\",\"base-type\":\"type/BigInteger\",\"lib/uuid\":\"6130941a-75d5-42b1-bf16-96243dc747c0\"},9]],\"fields\":[[\"field\",{\"effective-type\":\"type/BigInteger\",\"base-type\":\"type/BigInteger\",\"lib/uuid\":\"94b0a266-9e08-41a5-9b18-f640f5b0efa0\"},9],[\"field\",{\"effective-type\":\"type/Integer\",\"base-type\":\"type/Integer\",\"lib/uuid\":\"20d5ca81-67eb-43cc-9a81-24333ebd7150\"},14],[\"field\",{\"effective-type\":\"type/Float\",\"base-type\":\"type/Float\",\"lib/uuid\":\"22e39977-62a1-47f0-b996-47cbe799f2e2\"},5],[\"field\",{\"effective-type\":\"type/DateTime\",\"base-type\":\"type/DateTime\",\"lib/uuid\":\"18ca38cc-0b37-458e-b813-0e148fb83e35\"},13]],\"filters\":[[\"time-interval\",{\"lib/uuid\":\"73441961-63e5-4db5-a0cf-a9afaad57154\"},[\"field\",{\"effective-type\":\"type/DateTime\",\"base-type\":\"type/DateTime\",\"lib/uuid\":\"7e00f294-640f-4788-b5ba-136ab51bac10\"},13],-12,\"month\"],[\"in\",{\"lib/uuid\":\"d841c58f-e3c2-4424-ae53-2f39d3bf0e95\"},[\"field\",{\"lib/uuid\":\"57b9b720-7fd7-415e-b0c2-1e4725982cbf\",\"base-type\":\"type/Text\",\"effective-type\":\"type/Text\",\"source-field\":14},18],\"Doohickey\",\"Gadget\",\"Gizmo\",\"Widget\"],[\"in\",{\"lib/uuid\":\"2eecee50-25e7-473f-814b-785feade45d8\"},[\"field\",{\"lib/uuid\":\"b409012c-aad0-45d3-8dfd-3a4a4f079138\",\"base-type\":\"type/Text\",\"effective-type\":\"type/Text\",\"source-field\":14},18],\"Doohickey\",\"Gizmo\",\"Gadget\",\"Widget\"]],\"source-table\":2}]}",
:id 38,
:parameter_mappings "[]",
:display "boxplot",
:archived_directly false,
:entity_id "-1mRtcrAiZoe-GjYrQFHX",
:collection_preview true,
:visualization_settings
"{\"graph.show_goal\":false,\"boxplot.points_mode\":\"outliers\",\"graph.y_axis.title_text\":\"Order value, $\",\"graph.show_values\":true,\"graph.x_axis.labels_enabled\":false,\"boxplot.show_values_mode\":\"median\",\"graph.series_order_dimension\":null,\"graph.metrics\":[\"sum\"],\"graph.series_order\":null,\"boxplot.show_mean\":true,\"series_settings\":{\"sum\":{\"color\":\"#7172AD\"}},\"graph.x_axis.scale\":\"ordinal\",\"graph.dimensions\":[\"CATEGORY\"]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T12:39:10.331238Z",
:public_uuid nil}
{:cache_invalidated_at #t "2026-02-23T19:43:39.386060Z",
:description "Total number of orders in the current quarter.",
:archived false,
:collection_position nil,
:source_card_id nil,
:table_id 2,
:result_metadata
"[{\"description\":\"The date and time an order was submitted.\",\"database_type\":\"TIMESTAMP\",\"semantic_type\":\"type/CreationTimestamp\",\"table_id\":2,\"lib/deduplicated-name\":\"CREATED_AT\",\"lib/original-name\":\"CREATED_AT\",\"lib/breakout?\":true,\"unit\":\"quarter\",\"name\":\"CREATED_AT\",\"lib/source\":\"source/table-defaults\",\"lib/source-column-alias\":\"CREATED_AT\",\"lib/original-display-name\":\"Created At\",\"source\":\"breakout\",\"field_ref\":[\"field\",13,{\"temporal-unit\":\"quarter\"}],\"effective_type\":\"type/DateTime\",\"active\":true,\"id\":13,\"lib/desired-column-alias\":\"CREATED_AT\",\"metabase.lib.field/temporal-unit\":\"quarter\",\"position\":7,\"visibility_type\":\"normal\",\"inherited_temporal_unit\":\"quarter\",\"display_name\":\"Created At: Quarter\",\"fingerprint\":{\"global\":{\"distinct-count\":10001,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2022-04-30T18:56:13.352Z\",\"latest\":\"2026-04-19T14:07:15.657Z\"}}},\"base_type\":\"type/DateTime\"},{\"database_type\":\"BIGINT\",\"semantic_type\":\"type/Quantity\",\"lib/deduplicated-name\":\"count\",\"lib/original-name\":\"count\",\"name\":\"count\",\"lib/source\":\"source/aggregations\",\"lib/source-column-alias\":\"count\",\"source\":\"aggregation\",\"field_ref\":[\"aggregation\",0],\"effective_type\":\"type/BigInteger\",\"lib/desired-column-alias\":\"count\",\"display_name\":\"Count\",\"fingerprint\":{\"global\":{\"distinct-count\":1,\"nil%\":0.0},\"type\":{\"type/Number\":{\"min\":1650.0,\"q1\":1650.0,\"q3\":1650.0,\"max\":1650.0,\"sd\":null,\"avg\":1650.0}}},\"base_type\":\"type/BigInteger\"}]",
:initially_published_at nil,
:database_id 1,
:enable_embedding false,
:collection_id 2,
:query_type "query",
:name "Total orders this quarter",
:last_used_at #t "2026-02-23T19:43:46.351379Z",
:type "question",
:creator_id 13371338,
:updated_at #t "2026-02-23T19:43:39.391484Z",
:made_public_by_id nil,
:embedding_params nil,
:cache_ttl nil,
:dataset_query
"{\"lib/type\":\"mbql/query\",\"database\":1,\"stages\":[{\"source-table\":2,\"breakout\":[[\"field\",{\"effective-type\":\"type/DateTime\",\"base-type\":\"type/DateTime\",\"lib/uuid\":\"3d890b37-2691-40d6-9d2e-4848414c32a1\",\"temporal-unit\":\"quarter\"},13]],\"lib/type\":\"mbql.stage/mbql\",\"aggregation\":[[\"count\",{\"lib/uuid\":\"f466596a-a489-4f6d-ab22-6943a17207fc\"}]],\"filters\":[[\"in\",{\"lib/uuid\":\"797e8e68-69d2-4703-b403-a7aeadaae56e\"},[\"field\",{\"lib/uuid\":\"102ccf96-9fd6-4955-91cc-d8114aad5d74\",\"effective-type\":\"type/Text\",\"base-type\":\"type/Text\",\"source-field\":14},18],\"Doohickey\",\"Gadget\",\"Gizmo\",\"Widget\"],[\"time-interval\",{\"lib/uuid\":\"6cb3eb0a-1096-4ad1-8229-0efe52eaf3b2\"},[\"field\",{\"effective-type\":\"type/DateTime\",\"lib/uuid\":\"9a2b0699-187b-4710-b451-95ecb1891d70\",\"base-type\":\"type/DateTime\"},13],0,\"quarter\"]]}]}",
:id 39,
:parameter_mappings "[]",
:display "scalar",
:archived_directly false,
:entity_id "YeKGeCqzoVP1hWDERjPKG",
:collection_preview true,
:visualization_settings
"{\"graph.dimensions\":[\"CREATED_AT\"],\"graph.x_axis.scale\":\"timeseries\",\"scalar.field\":\"count\",\"scalar.segments\":[{\"color\":\"#E75454\",\"label\":\"Low\",\"max\":1500,\"min\":0},{\"min\":1501,\"max\":1700,\"color\":\"#51528D\",\"label\":\"Medium\"},{\"min\":1701,\"max\":10000,\"color\":\"#689735\",\"label\":\"High\"}],\"graph.metrics\":[\"count\"]}",
:metabase_version nil,
:parameters "[]",
:created_at #t "2026-02-23T19:01:20.786884Z",
:public_uuid nil}),
:dashboardcard_series (),
:collection
({:authority_level nil,
:description "Some examples to get started with",
:archived false,
:slug "examples",
:archive_operation_id nil,
:name "Examples",
:personal_owner_id nil,
:type nil,
:is_sample true,
:id 2,
:archived_directly nil,
:entity_id "HyB3nRtqb7pBPhFG26evI",
:location "/",
:namespace nil,
:created_at #t "2026-02-23T11:14:53.782096Z"}
{:authority_level nil,
:description "Questions and metrics used for the parent dashboard",
:archived true,
:slug "e_commerce",
:archive_operation_id "1e52f2e4-1304-4e09-9e0e-1dce5ea843af",
:name "E-commerce",
:personal_owner_id nil,
:type nil,
:is_sample true,
:id 3,
:archived_directly true,
:entity_id "54O0IbgCzm290Nnxf1wRH",
:location "/2/",
:namespace nil,
:created_at #t "2026-02-23T11:14:53.782096Z"}),
:parameter_card ()}