Hi all,
i'm using Metabase 0.47.5 hosted on Docker with postgres as application database, and sql-server as source database to analize.
I am using the weekday()
function to deduce the day of the week on which orders are placed.
The documentation says that:
### weekday
Takes a datetime and returns an integer (1-7) with the number of the day of the week.
case(
weekday([Created At]) = 1, "Sunday",
weekday([Created At]) = 2, "Monday",
weekday([Created At]) = 3, "Tuesday",
weekday([Created At]) = 4, "Wednesday",
weekday([Created At]) = 5, "Thursday",
weekday([Created At]) = 6, "Friday",
weekday([Created At]) = 7, "Saturday")
So I assume that 1= Sunday etc. But when i use a custom column to get the weekday of my orders, i get the following response (see the attached screenshot for further details):
Monday 23/10/2023 has WeedDay 1, but i expected 2, based on documentation., and so on for all the records.
In the Admin Settings, section Localization I've found the following setting, regarding the first day of the week:
I assume that FIRST DAY OF WEEK -> Sunday so Orders created on Sunday -> weekday(Sunday) = 1, Orders created on Monday -> weekday(Monday) = 2.
Is my statement correct? I'm doing something wrong or is this a bug?
Thank you,
A.
Here is my troubleshooting information:
{
"browser-info": {
"language": "it-IT",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.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.20.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20.1+1",
"os.name": "Linux",
"os.version": "5.10.102.1-microsoft-standard-WSL2",
"user.language": "en",
"user.timezone": "Europe/Rome"
},
"metabase-info": {
"databases": [
"postgres",
"mongo",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "15.1 (Debian 15.1-1.pgdg110+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-10-20",
"tag": "v0.47.5",
"branch": "?",
"hash": "e7ee12e"
},
"settings": {
"report-timezone": "Europe/Rome"
}
}
}