Picture won't help much. I click the dropdown, it waits 10-15 seconds, then shows the regular filter box.
Logs are big. Looks like a missing column which makes no sense as style is definitely a column. I was getting the same error when I select the question and it carries across the date filter.
{:via
[{:type clojure.lang.ExceptionInfo,
:message "Error executing query: ERROR: column source.style does not exist\n Position: 20",
:data
{:driver :postgres,
:sql
["-- Metabase"
"SELECT"
" \"source\".\"style\" AS \"style\""
"FROM"
" ("
" SELECT"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) AS \"Date - Registration Dimdateid__datekey\","
" \"source\".\"Short Style\" AS \"Short Style\","
" SUM(\"source\".\"noofregistrations\") AS \"sum\","
" LAG(SUM(\"source\".\"noofregistrations\"), 1) OVER ("
" PARTITION BY \"source\".\"Short Style\""
" ORDER BY"
" \"source\".\"Short Style\" ASC,"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) ASC"
" ) AS \"Previous Year\""
" FROM"
" ("
" SELECT"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) AS \"Date - Registration Dimdateid__datekey\","
" \"source\".\"Short Style\" AS \"Short Style\","
" \"source\".\"noofregistrations\" AS \"noofregistrations\""
" FROM"
" ("
" SELECT"
" \"public\".\"factregistration\".\"factregistrationid\" AS \"factregistrationid\","
" \"public\".\"factregistration\".\"noofregistrations\" AS \"noofregistrations\","
" TRIM("
" substring("
" \"Model - Dimmodelid\".\"style\""
" FROM"
" ?"
" )"
" ) AS \"Short Style\","
" \"Date - Registration Dimdateid\".\"datekey\" AS \"Date - Registration Dimdateid__datekey\","
" \"Euro Step - Dimeurostepid\".\"eurostepcode\" AS \"Euro Step - Dimeurostepid__eurostepcode\","
" \"Euro Step - Dimeurostepid\".\"eurostep\" AS \"Euro Step - Dimeurostepid__eurostep\","
" \"Model - Dimmodelid\".\"manufacturermcriscode\" AS \"Model - Dimmodelid__manufacturermcriscode\","
" \"Model - Dimmodelid\".\"manufacturerdvlacode\" AS \"Model - Dimmodelid__manufacturerdvlacode\","
" \"Model - Dimmodelid\".\"mcrismakecode\" AS \"Model - Dimmodelid__mcrismakecode\","
" \"Model - Dimmodelid\".\"dvlamakecode\" AS \"Model - Dimmodelid__dvlamakecode\","
" \"Model - Dimmodelid\".\"codemcris\" AS \"Model - Dimmodelid__codemcris\","
" \"Model - Dimmodelid\".\"codedvla\" AS \"Model - Dimmodelid__codedvla\","
" \"Model - Dimmodelid\".\"manufacturer\" AS \"Model - Dimmodelid__manufacturer\","
" \"Model - Dimmodelid\".\"name\" AS \"Model - Dimmodelid__name\","
" \"Model - Dimmodelid\".\"alternatename\" AS \"Model - Dimmodelid__alternatename\","
" \"Model - Dimmodelid\".\"modelseries\" AS \"Model - Dimmodelid__modelseries\","
" \"Model - Dimmodelid\".\"enginecapacity\" AS \"Model - Dimmodelid__enginecapacity\","
" \"Model - Dimmodelid\".\"maxnetpower_kw\" AS \"Model - Dimmodelid__maxnetpower_kw\","
" \"Model - Dimmodelid\".\"style\" AS \"Model - Dimmodelid__style\","
" \"Model - Dimmodelid\".\"typeapprovalcode\" AS \"Model - Dimmodelid__typeapprovalcode\","
" \"Model - Dimmodelid\".\"typeapprovalcategory\" AS \"Model - Dimmodelid__typeapprovalcategory\","
" \"Model - Dimmodelid\".\"minpower15_30\" AS \"Model - Dimmodelid__minpower15_30\","
" \"Model - Dimmodelid\".\"powertrain\" AS \"Model - Dimmodelid__powertrain\","
" \"Model - Dimmodelid\".\"market\" AS \"Model - Dimmodelid__market\","
" \"Model - Dimmodelid\".\"engineband500\" AS \"Model - Dimmodelid__engineband500\","
" \"Model - Dimmodelid\".\"enginebandelectric\" AS \"Model - Dimmodelid__enginebandelectric\","
" \"Postcode Area - Dimpostcodeareaid\".\"postcodearea\" AS \"Postcode Area - Dimpostcodeareaid__postcodearea\","
" \"Postcode Area - Dimpostcodeareaid\".\"mcicounty\" AS \"Postcode Area - Dimpostcodeareaid__mcicounty\","
" \"Postcode Area - Dimpostcodeareaid\".\"mciregion\" AS \"Postcode Area - Dimpostcodeareaid__mciregion\","
" \"Postcode Area - Dimpostcodeareaid\".\"mcicountry\" AS \"Postcode Area - Dimpostcodeareaid__mcicountry\","
" \"Postcode Area - Dimpostcodeareaid\".\"centroidlongitude\" AS \"Postcode Area - Dimpostcodeareaid__centroidlongitude\","
" \"Postcode Area - Dimpostcodeareaid\".\"centroidlatitude\" AS \"Postcode Area - Dimpostcodeareaid__centroidlatitude\","
" \"Subscriber - Dimsubscriberid\".\"subscribercode\" AS \"Subscriber - Dimsubscriberid__subscribercode\","
" \"Subscriber - Dimsubscriberid\".\"subscriber\" AS \"Subscriber - Dimsubscriberid__subscriber\""
" FROM"
" \"public\".\"factregistration\""
" LEFT JOIN \"public\".\"dimdate\" AS \"Date - Registration Dimdateid\" ON \"public\".\"factregistration\".\"registration_dimdateid\" = \"Date - Registration Dimdateid\".\"datekey\""
" LEFT JOIN \"public\".\"dimeurostep\" AS \"Euro Step - Dimeurostepid\" ON \"public\".\"factregistration\".\"dimeurostepid\" = \"Euro Step - Dimeurostepid\".\"dimeurostepid\""
" LEFT JOIN \"public\".\"dimmodel\" AS \"Model - Dimmodelid\" ON \"public\".\"factregistration\".\"dimmodelid\" = \"Model - Dimmodelid\".\"dimmodelid\""
" LEFT JOIN \"public\".\"dimpostcodearea\" AS \"Postcode Area - Dimpostcodeareaid\" ON \"public\".\"factregistration\".\"dimpostcodeareaid\" = \"Postcode Area - Dimpostcodeareaid\".\"dimpostcodeareaid\""
" LEFT JOIN \"public\".\"dimsubscriber\" AS \"Subscriber - Dimsubscriberid\" ON \"public\".\"factregistration\".\"dimsubscriberid\" = \"Subscriber - Dimsubscriberid\".\"dimsubscriberid\""
" WHERE"
" ("
" \"Date - Registration Dimdateid\".\"datekey\" >= DATE_TRUNC('year', (NOW() + INTERVAL '-2 year'))"
" )"
" AND ("
" \"Date - Registration Dimdateid\".\"datekey\" < DATE_TRUNC('year', (NOW() + INTERVAL '1 year'))"
" )"
" ) AS \"source\""
" ) AS \"source\""
" GROUP BY"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ),"
" \"source\".\"Short Style\""
" ORDER BY"
" \"source\".\"Short Style\" ASC,"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) ASC"
" ) AS \"source\""
"WHERE"
" ("
" ("
" ("
" ("
" CAST(\"source\".\"sum\" AS float) / NULLIF(\"source\".\"Previous Year\", 0)"
" ) - 1"
" ) * 100"
" ) IS NOT NULL"
" )"
" AND (\"source\".\"style\" IS NOT NULL)"
"GROUP BY"
" \"source\".\"style\""
"LIMIT"
" 1000"],
:params ("^[^;\\/]*"),
:type :invalid-query},
:at [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__87686$fn__87687 invoke "execute.clj" 716]}
{:type org.postgresql.util.PSQLException,
:message "ERROR: column source.style does not exist\n Position: 20",
:at [org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse "QueryExecutorImpl.java" 2725]}],
:trace
[[org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse "QueryExecutorImpl.java" 2725]
[org.postgresql.core.v3.QueryExecutorImpl processResults "QueryExecutorImpl.java" 2412]
[org.postgresql.core.v3.QueryExecutorImpl execute "QueryExecutorImpl.java" 371]
[org.postgresql.jdbc.PgStatement executeInternal "PgStatement.java" 502]
[org.postgresql.jdbc.PgStatement execute "PgStatement.java" 419]
[org.postgresql.jdbc.PgPreparedStatement executeWithFlags "PgPreparedStatement.java" 194]
[org.postgresql.jdbc.PgPreparedStatement executeQuery "PgPreparedStatement.java" 137]
[com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeQuery "NewProxyPreparedStatement.java" 743]
[metabase.driver.sql_jdbc.execute$fn__87614 invokeStatic "execute.clj" 565]
[metabase.driver.sql_jdbc.execute$fn__87614 invoke "execute.clj" 563]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invokeStatic "execute.clj" 578]
[metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invoke "execute.clj" 574]
[metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__87686$fn__87687 invoke "execute.clj" 714]
[metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__87686 invoke "execute.clj" 713]
[metabase.driver.sql_jdbc.execute$fn__87492$fn__87493 invoke "execute.clj" 398]
[metabase.driver.sql_jdbc.execute$do_with_resolved_connection87462__87463 invokeStatic "execute.clj" 338]
[metabase.driver.sql_jdbc.execute$do_with_resolved_connection87462__87463 invoke "execute.clj" 321]
[metabase.driver.sql_jdbc.execute$fn__87492 invokeStatic "execute.clj" 392]
[metabase.driver.sql_jdbc.execute$fn__87492 invoke "execute.clj" 390]
[clojure.lang.MultiFn invoke "MultiFn.java" 244]
[metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 707]
[metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 693]
[metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 704]
[metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 693]
[metabase.driver.sql_jdbc$fn__115850 invokeStatic "sql_jdbc.clj" 79]
[metabase.driver.sql_jdbc$fn__115850 invoke "sql_jdbc.clj" 77]
[clojure.lang.MultiFn invoke "MultiFn.java" 244]
[metabase.query_processor.pipeline$_STAR_execute_STAR_ invokeStatic "pipeline.clj" 52]
[metabase.query_processor.pipeline$_STAR_execute_STAR_ invoke "pipeline.clj" 39]
[metabase.query_processor.pipeline$_STAR_run_STAR_ invokeStatic "pipeline.clj" 102]
[metabase.query_processor.pipeline$_STAR_run_STAR_ invoke "pipeline.clj" 95]
[metabase.query_processor.execute$run invokeStatic "execute.clj" 62]
[metabase.query_processor.execute$run invoke "execute.clj" 56]
[metabase.query_processor.middleware.update_used_cards$update_used_cards_BANG_76031__76032$fn__76033
invoke
"update_used_cards.clj"
60]
[metabase.query_processor.execute$add_native_form_to_result_metadata$fn__76048 invoke "execute.clj" 25]
[metabase.query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__76054
invoke
"execute.clj"
36]
[metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___76004
invoke
"cache.clj"
241]
[metabase.query_processor.middleware.permissions$check_query_permissions$fn__72676 invoke "permissions.clj" 148]
[metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__73397
invoke
"enterprise.clj"
51]
[metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__73407
invoke
"enterprise.clj"
64]
[metabase.query_processor.execute$execute76081__76082$fn__76083 invoke "execute.clj" 94]
[metabase.query_processor.setup$do_with_qp_setup73951__73952 invokeStatic "setup.clj" 225]
[metabase.query_processor.setup$do_with_qp_setup73951__73952 invoke "setup.clj" 216]
[metabase.query_processor.execute$execute76081__76082 invokeStatic "execute.clj" 93]
[metabase.query_processor.execute$execute76081__76082 invoke "execute.clj" 89]
[metabase.query_processor$process_query_STAR__STAR_ invokeStatic "query_processor.clj" 49]
[metabase.query_processor$process_query_STAR__STAR_ invoke "query_processor.clj" 44]
[metabase.query_processor.middleware.enterprise$fn__73424$handle_audit_app_internal_queries__73425$fn__73427
invoke
"enterprise.clj"
96]
[metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__73435
invoke
"enterprise.clj"
103]
[metabase.query_processor.middleware.process_userland_query$process_userland_query_middleware78594__78595$fn__78596
invoke
"process_userland_query.clj"
204]
[metabase.query_processor.middleware.catch_exceptions$catch_exceptions78659__78660$fn__78661
invoke
"catch_exceptions.clj"
125]
[metabase.query_processor$process_query78700__78701$fn__78702 invoke "query_processor.clj" 80]
[metabase.query_processor.setup$do_with_canceled_chan73946__73947$fn__73948 invoke "setup.clj" 189]
[metabase.query_processor.setup$do_with_database_local_settings73939__73940$fn__73941 invoke "setup.clj" 181]
[metabase.query_processor.setup$do_with_driver73932__73933$fn__73934$fn__73935 invoke "setup.clj" 166]
[metabase.driver$do_with_driver invokeStatic "driver.clj" 106]
[metabase.driver$do_with_driver invoke "driver.clj" 101]
[metabase.query_processor.setup$do_with_driver73932__73933$fn__73934 invoke "setup.clj" 165]
[metabase.query_processor.setup$do_with_metadata_provider73923__73924$fn__73925$fn__73928 invoke "setup.clj" 151]
[metabase.query_processor.store$do_with_metadata_provider59833__59834 invokeStatic "store.clj" 170]
[metabase.query_processor.store$do_with_metadata_provider59833__59834 invoke "store.clj" 150]
[metabase.query_processor.store$do_with_metadata_provider59833__59834 invokeStatic "store.clj" 159]
[metabase.query_processor.store$do_with_metadata_provider59833__59834 invoke "store.clj" 150]
[metabase.query_processor.setup$do_with_metadata_provider73923__73924$fn__73925 invoke "setup.clj" 150]
[metabase.query_processor.setup$do_with_resolved_database73913__73914$fn__73915 invoke "setup.clj" 128]
[metabase.query_processor.setup$do_with_qp_setup73951__73952 invokeStatic "setup.clj" 232]
[metabase.query_processor.setup$do_with_qp_setup73951__73952 invoke "setup.clj" 216]
[metabase.query_processor$process_query78700__78701 invokeStatic "query_processor.clj" 78]
[metabase.query_processor$process_query78700__78701 invoke "query_processor.clj" 71]
[metabase.query_processor$process_query78700__78701 invokeStatic "query_processor.clj" 74]
[metabase.query_processor$process_query78700__78701 invoke "query_processor.clj" 71]
[metabase.models.params.custom_values$values_from_card102238__102239 invokeStatic "custom_values.clj" 117]
[metabase.models.params.custom_values$values_from_card102238__102239 invoke "custom_values.clj" 96]
[metabase.api.dashboard$filter_values_from_field_refs$iter__103049__103053$fn__103054 invoke "dashboard.clj" 1062]
[clojure.lang.LazySeq force "LazySeq.java" 50]
[clojure.lang.LazySeq realize "LazySeq.java" 89]
[clojure.lang.LazySeq seq "LazySeq.java" 106]
[clojure.lang.RT seq "RT.java" 555]
[clojure.core$seq__5486 invokeStatic "core.clj" 139]
[clojure.core$map$fn__5954 invoke "core.clj" 2763]
[clojure.lang.LazySeq force "LazySeq.java" 50]
[clojure.lang.LazySeq realize "LazySeq.java" 89]
[clojure.lang.LazySeq seq "LazySeq.java" 106]
[clojure.lang.Cons next "Cons.java" 41]
[clojure.lang.RT next "RT.java" 733]
[clojure.core$next__5470 invokeStatic "core.clj" 64]
[clojure.core$some invokeStatic "core.clj" 2718]
[clojure.core$some invoke "core.clj" 2709]
[metabase.api.dashboard$filter_values_from_field_refs invokeStatic "dashboard.clj" 1064]
[metabase.api.dashboard$filter_values_from_field_refs invoke "dashboard.clj" 1052]
[metabase.api.dashboard$chain_filter103082__103083 invokeStatic "dashboard.clj" 1102]
[metabase.api.dashboard$chain_filter103082__103083 invoke "dashboard.clj" 1086]
[metabase.api.dashboard$param_values103091__103092$fn__103093 invoke "dashboard.clj" 1145]
[metabase.models.params.custom_values$parameter__GT_values102246__102247 invokeStatic "custom_values.clj" 154]
[metabase.models.params.custom_values$parameter__GT_values102246__102247 invoke "custom_values.clj" 139]
[metabase.api.dashboard$param_values103091__103092 invokeStatic "dashboard.clj" 1142]
[metabase.api.dashboard$param_values103091__103092 invoke "dashboard.clj" 1122]
[metabase.api.dashboard$param_values103091__103092 invokeStatic "dashboard.clj" 1130]
[metabase.api.dashboard$param_values103091__103092 invoke "dashboard.clj" 1122]
[metabase.api.dashboard$fn__103096$fn__103098 invoke "dashboard.clj" 1158]
[metabase.api.dashboard$fn__103096 invokeStatic "dashboard.clj" 1157]
[metabase.api.dashboard$fn__103096 invoke "dashboard.clj" 1147]
[compojure.core$wrap_response$fn__54238 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__54222 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__54227 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 151]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[metabase.server.middleware.auth$enforce_authentication$fn__104726 invoke "auth.clj" 18]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250 invoke "core.clj" 200]
[compojure.core$make_context$handler__54278 invoke "core.clj" 290]
[compojure.core$make_context$fn__54282 invoke "core.clj" 300]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$make_context$fn__54282 invoke "core.clj" 301]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 33]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[clojure.lang.Var invoke "Var.java" 395]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[metabase.api.routes$fn__109391$fn__109394 invoke "routes.clj" 75]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 667]
[clojure.core$apply invoke "core.clj" 662]
[metabase.server.routes$fn__110133$fn__110134 doInvoke "routes.clj" 73]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250 invoke "core.clj" 200]
[compojure.core$make_context$handler__54278 invoke "core.clj" 290]
[compojure.core$make_context$fn__54282 invoke "core.clj" 300]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 153]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__54231 invoke "core.clj" 152]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250$f__54251$respond_SINGLEQUOTE___54252 invoke "core.clj" 197]
[metabase.server.routes$fn__110116$fn__110118 invoke "routes.clj" 47]
[compojure.core$routes$fn__54250$f__54251 invoke "core.clj" 198]
[compojure.core$routes$fn__54250 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__106855 invoke "exceptions.clj" 111]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__106852 invoke "exceptions.clj" 100]
[metabase.server.middleware.log$log_api_call$fn__110499$fn__110500$fn__110501 invoke "log.clj" 233]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invokeStatic "diagnostic.clj" 17]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invoke "diagnostic.clj" 12]
[metabase.server.middleware.log$log_api_call$fn__110499$fn__110500 invoke "log.clj" 224]
[toucan2.execute$do_with_call_counts invokeStatic "execute.clj" 112]
[toucan2.execute$do_with_call_counts invoke "execute.clj" 103]
[metabase.server.middleware.log$log_api_call$fn__110499 invoke "log.clj" 223]
[metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__114221 invoke "browser_cookie.clj" 40]
[metabase.server.middleware.security$add_security_headers$fn__106811 invoke "security.clj" 273]
[ring.middleware.json$wrap_json_body$fn__114480 invoke "json.clj" 64]
[metabase.server.middleware.offset_paging$handle_paging$fn__96332 invoke "offset_paging.clj" 56]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__55883 invoke "json.clj" 88]
[ring.middleware.keyword_params$wrap_keyword_params$fn__114569 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__114588 invoke "params.clj" 77]
[metabase.server.middleware.misc$maybe_set_site_url$fn__70128 invoke "misc.clj" 59]
[metabase.server.middleware.session$reset_session_timeout$fn__72214 invoke "session.clj" 566]
[metabase.server.middleware.session$bind_current_user$fn__72180$fn__72181 invoke "session.clj" 459]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 438]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 421]
[metabase.server.middleware.session$bind_current_user$fn__72180 invoke "session.clj" 458]
[metabase.server.middleware.session$wrap_current_user_info$fn__72157 invoke "session.clj" 383]
[metabase.analytics.sdk$embedding_mw$embedding_mw_fn__78408 invoke "sdk.clj" 63]
[metabase.server.middleware.session$wrap_session_id$fn__72129 invoke "session.clj" 261]
[metabase.server.middleware.auth$wrap_static_api_key$fn__104734 invoke "auth.clj" 33]
[ring.middleware.cookies$wrap_cookies$fn__114408 invoke "cookies.clj" 200]
[metabase.server.middleware.misc$add_content_type$fn__70110 invoke "misc.clj" 28]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__70136 invoke "misc.clj" 75]
[ring.middleware.gzip$wrap_gzip$fn__114450 invoke "gzip.clj" 86]
[metabase.server.middleware.request_id$wrap_request_id$fn__110195 invoke "request_id.clj" 9]
[metabase.server.middleware.misc$bind_request$fn__70139 invoke "misc.clj" 91]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__114237 invoke "ssl.clj" 51]
[metabase.server$async_proxy_handler$fn__56852 invoke "server.clj" 77]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.StatisticsHandler handle "StatisticsHandler.java" 173]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 122]
[org.eclipse.jetty.server.Server handle "Server.java" 563]
[org.eclipse.jetty.server.HttpChannel$RequestDispatchable dispatch "HttpChannel.java" 1598]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 753]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 501]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 287]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 314]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 100]
[org.eclipse.jetty.io.SelectableChannelEndPoint$1 run "SelectableChannelEndPoint.java" 53]
[org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy runTask "AdaptiveExecutionStrategy.java" 421]
[org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy consumeTask "AdaptiveExecutionStrategy.java" 390]
[org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy tryProduce "AdaptiveExecutionStrategy.java" 277]
[org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy run "AdaptiveExecutionStrategy.java" 199]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 411]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 969]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner doRunJob "QueuedThreadPool.java" 1194]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 1149]
[java.lang.Thread run nil -1]],
:cause "ERROR: column source.style does not exist\n Position: 20",
:message "Error executing query: ERROR: column source.style does not exist\n Position: 20",
:driver :postgres,
:sql
["-- Metabase"
"SELECT"
" \"source\".\"style\" AS \"style\""
"FROM"
" ("
" SELECT"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) AS \"Date - Registration Dimdateid__datekey\","
" \"source\".\"Short Style\" AS \"Short Style\","
" SUM(\"source\".\"noofregistrations\") AS \"sum\","
" LAG(SUM(\"source\".\"noofregistrations\"), 1) OVER ("
" PARTITION BY \"source\".\"Short Style\""
" ORDER BY"
" \"source\".\"Short Style\" ASC,"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) ASC"
" ) AS \"Previous Year\""
" FROM"
" ("
" SELECT"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) AS \"Date - Registration Dimdateid__datekey\","
" \"source\".\"Short Style\" AS \"Short Style\","
" \"source\".\"noofregistrations\" AS \"noofregistrations\""
" FROM"
" ("
" SELECT"
" \"public\".\"factregistration\".\"factregistrationid\" AS \"factregistrationid\","
" \"public\".\"factregistration\".\"noofregistrations\" AS \"noofregistrations\","
" TRIM("
" substring("
" \"Model - Dimmodelid\".\"style\""
" FROM"
" ?"
" )"
" ) AS \"Short Style\","
" \"Date - Registration Dimdateid\".\"datekey\" AS \"Date - Registration Dimdateid__datekey\","
" \"Euro Step - Dimeurostepid\".\"eurostepcode\" AS \"Euro Step - Dimeurostepid__eurostepcode\","
" \"Euro Step - Dimeurostepid\".\"eurostep\" AS \"Euro Step - Dimeurostepid__eurostep\","
" \"Model - Dimmodelid\".\"manufacturermcriscode\" AS \"Model - Dimmodelid__manufacturermcriscode\","
" \"Model - Dimmodelid\".\"manufacturerdvlacode\" AS \"Model - Dimmodelid__manufacturerdvlacode\","
" \"Model - Dimmodelid\".\"mcrismakecode\" AS \"Model - Dimmodelid__mcrismakecode\","
" \"Model - Dimmodelid\".\"dvlamakecode\" AS \"Model - Dimmodelid__dvlamakecode\","
" \"Model - Dimmodelid\".\"codemcris\" AS \"Model - Dimmodelid__codemcris\","
" \"Model - Dimmodelid\".\"codedvla\" AS \"Model - Dimmodelid__codedvla\","
" \"Model - Dimmodelid\".\"manufacturer\" AS \"Model - Dimmodelid__manufacturer\","
" \"Model - Dimmodelid\".\"name\" AS \"Model - Dimmodelid__name\","
" \"Model - Dimmodelid\".\"alternatename\" AS \"Model - Dimmodelid__alternatename\","
" \"Model - Dimmodelid\".\"modelseries\" AS \"Model - Dimmodelid__modelseries\","
" \"Model - Dimmodelid\".\"enginecapacity\" AS \"Model - Dimmodelid__enginecapacity\","
" \"Model - Dimmodelid\".\"maxnetpower_kw\" AS \"Model - Dimmodelid__maxnetpower_kw\","
" \"Model - Dimmodelid\".\"style\" AS \"Model - Dimmodelid__style\","
" \"Model - Dimmodelid\".\"typeapprovalcode\" AS \"Model - Dimmodelid__typeapprovalcode\","
" \"Model - Dimmodelid\".\"typeapprovalcategory\" AS \"Model - Dimmodelid__typeapprovalcategory\","
" \"Model - Dimmodelid\".\"minpower15_30\" AS \"Model - Dimmodelid__minpower15_30\","
" \"Model - Dimmodelid\".\"powertrain\" AS \"Model - Dimmodelid__powertrain\","
" \"Model - Dimmodelid\".\"market\" AS \"Model - Dimmodelid__market\","
" \"Model - Dimmodelid\".\"engineband500\" AS \"Model - Dimmodelid__engineband500\","
" \"Model - Dimmodelid\".\"enginebandelectric\" AS \"Model - Dimmodelid__enginebandelectric\","
" \"Postcode Area - Dimpostcodeareaid\".\"postcodearea\" AS \"Postcode Area - Dimpostcodeareaid__postcodearea\","
" \"Postcode Area - Dimpostcodeareaid\".\"mcicounty\" AS \"Postcode Area - Dimpostcodeareaid__mcicounty\","
" \"Postcode Area - Dimpostcodeareaid\".\"mciregion\" AS \"Postcode Area - Dimpostcodeareaid__mciregion\","
" \"Postcode Area - Dimpostcodeareaid\".\"mcicountry\" AS \"Postcode Area - Dimpostcodeareaid__mcicountry\","
" \"Postcode Area - Dimpostcodeareaid\".\"centroidlongitude\" AS \"Postcode Area - Dimpostcodeareaid__centroidlongitude\","
" \"Postcode Area - Dimpostcodeareaid\".\"centroidlatitude\" AS \"Postcode Area - Dimpostcodeareaid__centroidlatitude\","
" \"Subscriber - Dimsubscriberid\".\"subscribercode\" AS \"Subscriber - Dimsubscriberid__subscribercode\","
" \"Subscriber - Dimsubscriberid\".\"subscriber\" AS \"Subscriber - Dimsubscriberid__subscriber\""
" FROM"
" \"public\".\"factregistration\""
" LEFT JOIN \"public\".\"dimdate\" AS \"Date - Registration Dimdateid\" ON \"public\".\"factregistration\".\"registration_dimdateid\" = \"Date - Registration Dimdateid\".\"datekey\""
" LEFT JOIN \"public\".\"dimeurostep\" AS \"Euro Step - Dimeurostepid\" ON \"public\".\"factregistration\".\"dimeurostepid\" = \"Euro Step - Dimeurostepid\".\"dimeurostepid\""
" LEFT JOIN \"public\".\"dimmodel\" AS \"Model - Dimmodelid\" ON \"public\".\"factregistration\".\"dimmodelid\" = \"Model - Dimmodelid\".\"dimmodelid\""
" LEFT JOIN \"public\".\"dimpostcodearea\" AS \"Postcode Area - Dimpostcodeareaid\" ON \"public\".\"factregistration\".\"dimpostcodeareaid\" = \"Postcode Area - Dimpostcodeareaid\".\"dimpostcodeareaid\""
" LEFT JOIN \"public\".\"dimsubscriber\" AS \"Subscriber - Dimsubscriberid\" ON \"public\".\"factregistration\".\"dimsubscriberid\" = \"Subscriber - Dimsubscriberid\".\"dimsubscriberid\""
" WHERE"
" ("
" \"Date - Registration Dimdateid\".\"datekey\" >= DATE_TRUNC('year', (NOW() + INTERVAL '-2 year'))"
" )"
" AND ("
" \"Date - Registration Dimdateid\".\"datekey\" < DATE_TRUNC('year', (NOW() + INTERVAL '1 year'))"
" )"
" ) AS \"source\""
" ) AS \"source\""
" GROUP BY"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ),"
" \"source\".\"Short Style\""
" ORDER BY"
" \"source\".\"Short Style\" ASC,"
" DATE_TRUNC("
" 'year',"
" CAST("
" \"source\".\"Date - Registration Dimdateid__datekey\" AS timestamp"
" )"
" ) ASC"
" ) AS \"source\""
"WHERE"
" ("
" ("
" ("
" ("
" CAST(\"source\".\"sum\" AS float) / NULLIF(\"source\".\"Previous Year\", 0)"
" ) - 1"
" ) * 100"
" ) IS NOT NULL"
" )"
" AND (\"source\".\"style\" IS NOT NULL)"
"GROUP BY"
" \"source\".\"style\""
"LIMIT"
" 1000"],
:params ("^[^;\\/]*")}