Question 1682 is correct, it's on the new BQ driver.
Just looked at the browser console myself and it does bring up an error I don't see on other questions:
This is the metadata, I've removed the query as there doesn't seem to be anything wrong with it, I copy-pasted it into a new question and it worked straight away.
{
"description": null,
"archived": false,
"collection_position": null,
"table_id": null,
"result_metadata": null,
"creator": {
"email": "f",
"first_name": "",
"last_login": "2022-03-04T08:54:28.162903Z",
"is_qbnewb": false,
"is_superuser": true,
"id": 152,
"last_name": "",
"date_joined": "2021-12-30T16:48:12.330592Z",
"common_name": ""
},
"can_write": true,
"database_id": 101,
"enable_embedding": false,
"collection_id": 231,
"query_type": "native",
"name": "Order Volume Forecast",
"last_query_start": "2022-03-04T07:47:35.577872Z",
"dashboard_count": 0,
"average_query_time": 3581.8571428571428571,
"creator_id": 152,
"moderation_reviews": [
],
"updated_at": "2022-03-04T07:49:07.608079Z",
"made_public_by_id": null,
"embedding_params": null,
"cache_ttl": null,
"dataset_query": {
"database": 101,
"native": {
"template-tags": {
"#1441": {
"id": "c125561e-ff08-2bb3-7f28-2b2668abc672",
"name": "#1441",
"display-name": "#1441",
"type": "card",
"card-id": 1441
},
"Owner": {
"id": "4a48c234-ab72-ae7d-77ec-a3c099bee9b2",
"name": "Owner",
"display-name": "Owner",
"type": "dimension",
"required": false,
"widget-type": "category"
}
},
"query": ""
},
"type": "native"
},
"id": 1682,
"display": "line",
"last-edit-info": {
"id": 152,
"email": "",
"first_name": "",
"last_name": "",
"timestamp": "2022-03-04T07:49:07.649861Z"
},
"visualization_settings": {
"graph.show_goal": true,
"graph.show_values": true,
"table.columns": [
{
"name": "report_month",
"fieldRef": [
"field",
"report_month",
{
"base-type": "type/Date"
}
],
"enabled": true
},
{
"name": "scaled_order_volume_monthly",
"fieldRef": [
"field",
"scaled_order_volume_monthly",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "order_volume_fraction",
"fieldRef": [
"field",
"order_volume_fraction",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "one_months_ago",
"fieldRef": [
"field",
"one_months_ago",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "two_months_ago",
"fieldRef": [
"field",
"two_months_ago",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "three_months_ago",
"fieldRef": [
"field",
"three_months_ago",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "four_months_ago",
"fieldRef": [
"field",
"four_months_ago",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "five_months_ago",
"fieldRef": [
"field",
"five_months_ago",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "forecasted_order_volume",
"fieldRef": [
"field",
"forecasted_order_volume",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "fully_vested_deals",
"fieldRef": [
"field",
"fully_vested_deals",
{
"base-type": "type/Float"
}
],
"enabled": true
},
{
"name": "order_volume_monthly",
"fieldRef": [
"field",
"order_volume_monthly",
{
"base-type": "type/Float"
}
],
"enabled": true
}
],
"table.cell_column": "scaled_order_volume_monthly",
"graph.goal_label": "Global H1 Goal Line",
"graph.goal_value": 140000,
"graph.y_axis.auto_split": false,
"graph.metrics": [
"forecasted_order_volume"
],
"table.pivot_column": "five_months_ago",
"column_settings": {
"["name","forecasted_order_volume"]": {
"number_separators": ",."
},
"["name","order_volume_monthly"]": {
"number_separators": ",."
},
"["name","previous_6_months_volume"]": {
"number_separators": ",."
},
"["name","scaled_order_volume_monthly"]": {
"number_separators": ",."
},
"["name","one_months_ago"]": {
"number_separators": ",."
},
"["name","scaled_order_volume_forecast"]": {
"number_separators": ",."
},
"["name","report_month"]": {
"date_abbreviate": true
},
"["name","scaled_deal_amount_forecast"]": {
"number_style": "currency",
"number_separators": ",."
},
"["name","previous_6_months_scaled_vol"]": {
"number_separators": ",."
},
"["name","five_months_ago"]": {
"number_separators": ",."
},
"["name","three_months_ago"]": {
"number_separators": ",."
},
"["name","two_months_ago"]": {
"number_separators": ",."
},
"["name","deal_amount_monthly"]": {
"number_style": "currency",
"number_separators": ",."
},
"["name","order_volume_fraction"]": {
"number_separators": ",."
},
"["name","four_months_ago"]": {
"number_separators": ",."
}
},
"graph.y_axis.auto_range": true,
"graph.x_axis.scale": "timeseries",
"graph.dimensions": [
"report_month"
],
"stackable.stack_type": null
},
"collection": {
"authority_level": null,
"description": null,
"archived": false,
"slug": "finalized_dashboards_queries_florian",
"color": "#509EE3",
"name": "Finalized Dashboards/Queries Florian",
"personal_owner_id": null,
"id": 231,
"location": "/115/",
"namespace": null
},
"dataset": false,
"created_at": "2022-02-25T08:58:03.876972Z",
"public_uuid": null
}