My query shows the trend when the result is based on date, But when month the trend is not showing.
Can you help me how can I visualize with last month?
I want to make it like the attached picture.
My query shows the trend when the result is based on date, But when month the trend is not showing.
Can you help me how can I visualize with last month?
I want to make it like the attached picture.
Hi @shaonyuvi
Post "Diagnostic Info" from Admin > Troubleshooting.
Have you looked at https://www.metabase.com/docs/latest/questions/sharing/visualizing-results#trends ?
I don't understand what you are trying to do. If you want to visualize previous month, then filter out the current month.
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.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+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"os.name": "Linux",
"os.version": "5.4.196-108.356.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"sqlserver",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.13"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.4.1"
}
},
"run-mode": "prod",
"version": {
"date": "2022-08-16",
"tag": "v1.44.1",
"branch": "release-x.44.x",
"hash": "112f5aa"
},
"settings": {
"report-timezone": null
}
}
}
@shaonyuvi You need to return a date, otherwise Metabase cannot now it is a month, when you're using SQL.