Time Series Graph

Hi
Is it possible to spit both X axis and Y axis to club 2 time series graphs

Hi @Prajakta2021
It's currently not possible to have multiple X+Y axes at the same time. It would allow for more advanced things like this too:
https://github.com/metabase/metabase/issues/5416 - upvote by clicking :+1: on the first post
Currently on the Pivot Table allows for something like that.

Hi ,
I am trying to create multi series graph with shared Y axis. I got success at somewhat level but labels are not coming correct. Also some how when i added second question date range changed to 1970 to 2021.
Below is the graph i have created using 2 questions.
Both questions are having different base tables from Bigquery.

@Prajakta2021 It would be much easier to understand if you created an example with the Sample Dataset.
It doesn't look like you are trying to use a shared Y-axis, but a split axis instead.

Also, post "Diagnostic Info" from Admin > Troubleshooting.

hi ,
yes its spits axis. sorry about miss communication. sure will past codebelow

{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:89.0) Gecko/20100101 Firefox/89.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "5.4.0-1046-gcp",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"bigquery"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.3 (Debian 12.3-1.pgdg100+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-06-15",
"tag": "v0.39.4",
"branch": "release-x.39.x",
"hash": "f538050"
},
"settings": {
"report-timezone": null
}
}
}

@Prajakta2021
So I'm guessing that the only problem is to do with the X-axis?

Are you using SQL or GUI questions?
If GUI, what is the "Field Type" and "Casting" of those two date in Admin > Data Model > (db) > (table) > (column) :gear: ? And are you summarizing with the same granularity in both questions?
If SQL, are you casting as the same type?

Hi ,
I am using one question with SQL and another as simple question. But even for simple question base table is actually view created in bigquery

@Prajakta2021 So if one question is SQL and the other is GUI, then make sure they're using the same casting. Otherwise Metabase would have a hard time figuring out how to combine the questions.

Tried it. Created simple questions using bigquery views. and tried to incorporate both but still same issue of 1970 date range

@Prajakta2021 Since you're not providing any details on how to reproduce this, then I don't think I can help anymore.