Comparison day week from one year to another.
Hi !
I want to compare the date figures from one year to another year.
For example, compared January 1, 2019 to January 1, 2020.
This part works.
However, I have a custom entity with the days of the week: Monday, Tuesday, ... and I want to compare Wednesday January 1, 2020 to Wednesday January 2, 2019.
My problem is that on the layout, January 1, 2020 is shifted to Wednesday instead of Tuesday. So a comparison between January 1, 2020 and January 2, 2019 ...
On the first image, it is the rendering that I expect.
On the second image, it is the current rendering.
Do you have a lead?
I thank you in advance.
------------------------------
Sebastien LEGER
President
EXOSET
France
------------------------------
I want to compare the date figures from one year to another year.
For example, compared January 1, 2019 to January 1, 2020.
This part works.
However, I have a custom entity with the days of the week: Monday, Tuesday, ... and I want to compare Wednesday January 1, 2020 to Wednesday January 2, 2019.
My problem is that on the layout, January 1, 2020 is shifted to Wednesday instead of Tuesday. So a comparison between January 1, 2020 and January 2, 2019 ...
On the first image, it is the rendering that I expect.
On the second image, it is the current rendering.
Do you have a lead?
I thank you in advance.
------------------------------
Sebastien LEGER
President
EXOSET
France
------------------------------
0
Answers
-
Hi Sebastien,
What about having a second cube (set of cubes) called something like PY Comparable Day of Week? Populate those based upon the existing cube and using offset -364. If that works, then need to think about leap years and change accordingly.
Chris
------------------------------
Chris Hannan
Senior Solution Architect
Board Community
Australia
------------------------------
-------------------------------------------0
