Wrong Day of week

Bug reports
1

Hi,
I need to extract day of week from date.
If I use native function, it gets bad result

image
17/4/24 was wednesday, function returns thursday ("dimarts")

Being used native function:
image

and calculated field as
image

what's on? can we change anything?
thanks,
anna

{
"browser-info": {
"language": "ca",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "11.0.13+10-LTS-370",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "https://openjdk.java.net/",
"java.version": "11.0.13",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "11.0.13+10-LTS-370",
"os.name": "Linux",
"os.version": "3.10.0-1160.25.1.el7.x86_64",
"user.language": "en",
"user.timezone": "Europe/Madrid"
},
"metabase-info": {
"databases": [
"postgres",
"oracle"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.3"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
}
},
"run-mode": "prod",
"version": {
"date": "2024-04-10",
"tag": "v0.49.4",
"hash": "0fdefcf"
},
"settings": {
"report-timezone": null
}
}
}

2

If you go to Admin -> Localization Settings .. Can you check the first day of week setting there

image
image3024×1120 259 KB

e

3

Hi Tony, thanks a lot for your answer.
I checked that before and didn't work.

image
image1916×1124 111 KB

that's working days (it should be monday-friday with data, not sunday "diumenge")
this is the configuration I have now
image
image1075×208 16.2 KB

starts on "dilluns" monday AND THE PLOT STARTS ON "Dimarts" THURSDAY!!!

I change that to "diumenge" (sunday)
and the result is that sunday apears on first position, but data is still wrong

image
image2446×1109 132 KB

it's something more... if you use day of week with your data, you get right results?

4

Is it wrong when displayed as a table? I had a problem with MS SQL when the first day of the week in SQL was a Sunday rather than a Monday. The table was correct, the chart wrong.

5

you mean the same question viewed as table? yes, is still wrong

image
diumenge-->sunday it must be around zero