Trend line option now showing

[ed.s]

I have a question where the trend line switch doesn't appear at all. I have checked the data types for the dates and they seem correct.

Diagnostic info

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16.1+1-LTS",
    "java.vendor": "Azul Systems, Inc.",
    "java.vendor.url": "http://www.azul.com/",
    "java.version": "11.0.16.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16.1+1-LTS",
    "os.name": "Linux",
    "os.version": "4.4.0-1104-aws",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "heroku",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.8 (Ubuntu 13.8-1.pgdg20.04+1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.4.1"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-09-02",
      "tag": "v0.44.3",
      "branch": "release-x.44.x",
      "hash": "7d50282"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

[flamber]

Hi @ed.s
Your screenshot is only showing Goal toggled and doesn't even show if there's a Trend line toggle right below "Goal label".
But since you are using Stack 100%, then it will not show a trend line anyway, like we've already covered in Trend line not showing when selected

[ed.s]

Apologies. I have updated the original picture, I pushed the wrong screenshot.

[flamber]

@ed.s I'm simply not seeing enough information to know what the problem is.
Post the question metadata by going to the URL /api/card/123, where 123 is the question ID.

[ed.s]

{
description: null,
archived: false,
collection_position: null,
table_id: 30,
result_metadata: [
{
description: null,
semantic_type: "type/CreationDate",
coercion_strategy: null,
unit: "month",
name: "start_date",
settings: null,
field_ref: [
"field",
138,
{
temporal-unit: "month"
}
],
effective_type: "type/DateTimeWithLocalTZ",
id: 138,
visibility_type: "normal",
display_name: "Start Date",
fingerprint: {
global: {
distinct-count: 77,
nil%: 0.7081967213114754
},
type: {
type/DateTime: {
earliest: "2019-04-23",
latest: "2021-11-22"
}
}
},
base_type: "type/DateTimeWithLocalTZ"
},
{
description: null,
semantic_type: "type/Title",
coercion_strategy: null,
name: "title",
settings: null,
field_ref: [
"field",
131,
null
],
effective_type: "type/Text",
id: 131,
visibility_type: "normal",
display_name: "Title",
fingerprint: {
global: {
distinct-count: 300,
nil%: 0
},
type: {
type/Text: {
percent-json: 0,
percent-url: 0,
percent-email: 0,
percent-state: 0,
average-length: 15.904918032786885
}
}
},
base_type: "type/Text"
},
{
display_name: "Paid Spend %",
field_ref: [
"aggregation",
0
],
name: "Paid Spend %",
base_type: "type/Float",
effective_type: "type/Float",
semantic_type: null,
fingerprint: {
global: {
distinct-count: 274,
nil%: 0
},
type: {
type/Number: {
min: 2.243004968938503,
q1: 24.409488789534628,
q3: 56.67242934720758,
max: 97.71163560887639,
sd: 21.779603688627077,
avg: 41.5824054538631
}
}
}
},
{
display_name: "Organic Spend %",
field_ref: [
"aggregation",
1
],
name: "Organic Spend %",
base_type: "type/Float",
effective_type: "type/Float",
semantic_type: null,
fingerprint: {
global: {
distinct-count: 274,
nil%: 0
},
type: {
type/Number: {
min: 2.2883643911236136,
q1: 43.32757065279242,
q3: 75.59051121046538,
max: 97.7569950310615,
sd: 21.77960368862708,
avg: 58.4175945461369
}
}
}
}
],
creator: {
email: "ed.sparks@goatagency.com",
first_name: "Ed",
last_login: "2022-09-21T18:44:07.417747Z",
is_qbnewb: false,
is_superuser: true,
id: 1,
last_name: "Sparks",
date_joined: "2021-11-17T21:42:03.283057Z",
common_name: "Ed Sparks"
},
can_write: true,
database_id: 2,
enable_embedding: false,
collection_id: 15,
query_type: "query",
name: "Organic vs Ad Spend MoM",
last_query_start: "2022-09-26T11:09:38.045542Z",
dashboard_count: 1,
average_query_time: 2074.4,
creator_id: 1,
moderation_reviews: [ ],
updated_at: "2022-09-26T11:09:38.997711Z",
made_public_by_id: null,
embedding_params: null,
cache_ttl: null,
dataset_query: {
database: 2,
query: {
source-table: 30,
joins: [
{
fields: "none",
source-table: 42,
condition: [
"=",
[
"field",
134,
null
],
[
"field",
53,
{
join-alias: "Activations"
}
]
],
alias: "Activations"
},
{
fields: "none",
source-table: 117,
condition: [
"=",
[
"field",
51,
{
join-alias: "Activations"
}
],
[
"field",
875,
{
join-alias: "Adsets"
}
]
],
alias: "Adsets"
},
{
fields: "none",
source-table: 119,
condition: [
"=",
[
"field",
874,
{
join-alias: "Adsets"
}
],
[
"field",
885,
{
join-alias: "Ads"
}
]
],
alias: "Ads"
},
{
fields: "none",
source-table: 61,
condition: [
"=",
[
"field",
134,
null
],
[
"field",
552,
{
join-alias: "Posts"
}
]
],
alias: "Posts"
}
],
aggregation: [
[
"aggregation-options",
[
"*",
[
"/",
[
"sum",
[
"field",
904,
{
join-alias: "Ads"
}
]
],
[
"sum",
[
"+",
[
"field",
539,
{
join-alias: "Posts"
}
],
[
"field",
904,
{
join-alias: "Ads"
}
]
]
]
],
100
],
{
name: "Paid Spend %",
display-name: "Paid Spend %"
}
],
[
"aggregation-options",
[
"*",
[
"/",
[
"sum",
[
"field",
539,
{
join-alias: "Posts"
}
]
],
[
"sum",
[
"+",
[
"field",
539,
{
join-alias: "Posts"
}
],
[
"field",
904,
{
join-alias: "Ads"
}
]
]
]
],
100
],
{
name: "Organic Spend %",
display-name: "Organic Spend %"
}
]
],
breakout: [
[
"field",
138,
{
temporal-unit: "month"
}
],
[
"field",
131,
null
]
],
filter: [
"and",
[
"not-null",
[
"field",
530,
{
join-alias: "Posts"
}
]
],
[
"not-null",
[
"field",
888,
{
join-alias: "Ads"
}
]
],
[
"=",
[
"field",
553,
{
join-alias: "Posts"
}
],
"paid",
"Contracted",
"contracted"
],
[
">",
[
"field",
539,
{
join-alias: "Posts"
}
],
0
],
[
">",
[
"field",
904,
{
join-alias: "Ads"
}
],
0
],
[
">",
[
"field",
138,
null
],
"2020-01-01"
]
]
},
type: "query"
},
id: 471,
parameter_mappings: [ ],
display: "area",
entity_id: "HpLK3IhrGjK823Uarzfs_",
collection_preview: true,
last-edit-info: {
id: 1,
email: "ed.sparks@goatagency.com",
first_name: "Ed",
last_name: "Sparks",
timestamp: "2022-09-26T09:18:08.901846Z"
},
visualization_settings: {
graph.show_goal: true,
graph.show_trendline: true,
pivot_table.column_split: {
rows: [
[
"field",
138,
{
temporal-unit: "month"
}
]
],
columns: [ ],
values: [
[
"aggregation",
0
],
[
"aggregation",
1
]
]
},
graph.show_values: false,
graph.x_axis.labels_enabled: true,
graph.goal_label: "50%",
stackable.stack_display: "area",
graph.y_axis.labels_enabled: true,
graph.goal_value: 0.5,
graph.y_axis.scale: "linear",
graph.y_axis.auto_split: true,
graph.label_value_frequency: "all",
graph.metrics: [
"Paid Spend %",
"Organic Spend %"
],
graph.label_value_formatting: "auto",
column_settings: {
["name","Paid Spend %"]: {
number_style: "percent"
}
},
series_settings: {
Paid Spend %: {
color: "#227FD2",
line.interpolate: "cardinal",
line.marker_enabled: false,
line.missing: "interpolate"
},
Organic Spend %: {
color: "#ED8535",
line.interpolate: "cardinal",
line.marker_enabled: false
}
},
graph.y_axis.auto_range: true,
graph.x_axis.scale: "timeseries",
graph.dimensions: [
"start_date"
],
stackable.stack_type: "normalized"
},
collection: {
authority_level: null,
description: null,
archived: false,
slug: "management",
color: "#509EE3",
name: "Management",
personal_owner_id: null,
id: 15,
entity_id: "mXlW3he0bDr0Do1sHHjQ_",
location: "/",
namespace: null
},
parameters: [ ],
dataset: false,
created_at: "2022-09-21T19:13:33.663225Z",
public_uuid: null
}

[flamber]

@ed.s Your question is returning multiple series (multiple group-bys). It is really difficult to read the question metadata because it's not the raw output.

[ed.s]

I did have a second group by and as soon as it was removed, it gave me the option for the trendline.
Back to the original problem though of no trendline showing but that's already being addressed in github.