Trend for month wise data

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 ?
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/ Safari/537.36",
"vendor": "Google Inc."
"system-info": {
"file.encoding": "UTF-8",
"": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "",
"java.version": "11.0.16",
"": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"": "Linux",
"os.version": "5.4.196-108.356.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
"metabase-info": {
"databases": [
"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

I made this query for month, but it seems not working for trend.

@shaonyuvi You need to return a date, otherwise Metabase cannot now it is a month, when you're using SQL.