Change de period to compare with in a Trend visualization

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.
image

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

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?

@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.

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?

@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

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?

@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.

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

you are really patient with me, many thanks!!

@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.

1 Like

{
"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
}
}
}

First day I tried to do it, I saw saved Questions in my list, but it onlye appeared some of them. But now, I can't find Saved Questions :frowning:

@AQuer

  1. Upgrade to 0.41.1: https://github.com/metabase/metabase/releases/latest
  2. Upgrade to Java 11: https://www.metabase.com/docs/latest/operations-guide/java-versions.html

Then go to Ask a question > Simple question > at the bottom of the list, there's "Saved Questions"
Otherwise post a screenshot of what you're seeing.

Ok thaks, I ask IT for a upgrade.

Many thanks
have a nice weekend!

still here.... :frowning:

@AQuer Talk to your administrator and make sure that they haven't disabled the functionality:

1 Like

yes!!!
it was that!!! :partying_face::partying_face::partying_face::partying_face::partying_face:

A lot of thanks!!!!!