[Bug][Module Name] Bug title

[pedro-rbaptista-totvstechfin]

Search before asking

• [X] I had searched in the issues and found no similar issues.

What happened

In the Component and File-level Metrics dashboard, the views that transform dates into days of the week are performing the conversion in disagreement with the mysql documentation.

What do you expect to happen

According to https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_dayofweek : (1 = Sunday, 2 = Monday, …, 7 = Saturday)

But it is implemented like: (7 = Sunday, 1 = Monday, …, 6 = Saturday)

How to reproduce

Open the Component and File-level Metrics dashboard with data

Anything else

No response

Version

v1.0.0-beta11

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[pedro-rbaptista-totvstechfin]

Already resolved in main branch