Change de period to compare with in a Trend visualization

AQuer · November 4, 2021, 2:20pm

Hi!!
I need to plot a Trend, showin last month value, compared with the same month from the previous year.
I cannot see any option to change that... only the way it must be data grouped.

The data I have is a monthly value in each row.

flamber · November 4, 2021, 3:39pm

Hi @AQuer
You would have to filter the data, so it only returned those two rows if you are talking about the Trend visualization.

AQuer · November 5, 2021, 1:04pm

thanks flamber. I could'nt check it yet.
With notebook, is not possible to extract month from a date?

I understood I need to filter the data to get only 2 rows: one for the last month and the other for the same month from the previous year... this is only possible to get with sql, isn'it?

flamber · November 5, 2021, 1:11pm

@AQuer Currently I think it would be the easiest to do this in SQL. We're working on adding a lot more Custom Expressions, which will allow you to manipulate data more easily in the Notebook editor. Some of it might arrive in 0.42, some later.

AQuer · November 5, 2021, 1:21pm

Ok thanks, then I triy it with sql but the problem is that users can not reuse it if they don't know SQL language.
Theres a way to use a sql saved question as a data origin in a personalized question done in notebook?

flamber · November 5, 2021, 1:36pm

@AQuer Yes, using Saved Questions: https://www.metabase.com/docs/latest/users-guide/custom-questions.html#picking-your-starting-data
Or using Sub-Query variable: https://www.metabase.com/docs/latest/users-guide/referencing-saved-questions-in-queries.html

AQuer · November 5, 2021, 1:53pm

Sorry, I'm quite lost.
It's possible to use saved question as a Source in a NON SQL question? that's, from a questione done in the notebook?

How Can I choose a saved question here?

flamber · November 5, 2021, 1:57pm

@AQuer
Click "IND_NETEJA" and select Saved Questions and find the SQL question.
Perhaps I don't understand what you're trying to do, but then just do it in SQL. The GUI will not allow you to do everything, which is when you should use SQL.
Then perhaps in a later version it will be possible to do it in GUI and then you can update your questions.

AQuer · November 5, 2021, 2:56pm

Sorry....
if I click Ind_Neteja, I can choose another table

or if I click to the squares on the right, some columns...
but I can't see saved questions anywhere...
I'am admin user, so I think that's not because of my configuration

you are really patient with me, many thanks!!

flamber · November 5, 2021, 2:59pm

@AQuer Click "< DATAWAREHOUSE", then you can select "Saved Questions"
Otherwise simply start a new question.

Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.

AQuer · November 5, 2021, 3:02pm

{
"browser-info": {
"language": "es",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.108 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_131-b11",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_131",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.131-b11",
"os.name": "Linux",
"os.version": "3.10.0-1160.25.1.el7.x86_64",
"user.language": "en",
"user.timezone": "Europe/Madrid"
},
"metabase-info": {
"databases": [
"oracle",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.3"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.41.0",
"date": "2021-10-06",
"branch": "release-x.41.x",
"hash": "c529fe2"
},
"settings": {
"report-timezone": null
}
}
}