Deepsee - Functions with Time

Question

Question

JAQUELINE KRIEGER · Jul 3, 2017

Hi everybody,

I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work. Works only if I want to compare the months between the two years. If someone has some idea, i will appreciatte a lot.

Thanks.

Jaqueline Krieger

Discussion (4)1

Log in or sign up to continue

Sam Duncan · Jul 3, 2017

Hi Jaqueline,

This Developer Community post has some information that you may find useful: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...

It deals specifically with comparing results for this year to date versus the same time period in the previous year, but you might be able to apply some of the same concepts when writing your MDX expressions. Let me know if you need clarification, or if this doesn't enable you to make the calculations you intend.

Best,

Sam Duncan

1 0

score 0 · Answer 1 · 2017-07-04T10:31:42-04:00

JAQUELINE KRIEGER · Jul 4, 2017

Thanks a lot. It's very helpful this information

0 0

score 0 · Answer 2 · 2017-07-04T10:32:41-04:00

JAQUELINE KRIEGER · Jul 4, 2017

Thank you for your answer. It's also an alternative.

0 0

score 0 · Answer 3 · 2017-07-04T03:46:38-04:00

Hi Jaqueline,

Actually, it might be tricky to compare one week to another same week of the last year. The Same week may belong to different months for two different years.

Anyway you may consider trying with WeekNumber function for Time dimensions having something like this (Samples, Holefoods):