6 Replies Latest reply on Feb 7, 2018 4:34 PM by Hari Ankem

Week Difference

Nancy V Feb 7, 2018 2:25 PM

I have two dimensions - Test Week and Release week

The format of these fields are: 2017-01 (YYYY-WW)

How can i find the difference between both the week fields? I want a new field that will tell me Week X, where X is the difference between these two weeks

Example:

Test Week = 2017-48

Release Week = 2018-02

Difference = Week 6

1. Re: Week Difference

Hari Ankem Feb 7, 2018 2:53 PM (in response to Nancy V)

Try putting this in a calculated field:

DATEDIFF("week",
DATEPARSE("YYYY-ww",'2017-48'),
DATEPARSE("YYYY-ww",'2018-02')
)
Like Show 0 Likes(0)

Actions
2. Re: Week Difference

Deepak Rai Feb 7, 2018 2:56 PM (in response to Nancy V)
Hi Nancy,
Though Hari already Replied, but sometimes DATEPARSE does n't work so I come up with alternative.
Thanks
Deepak

Weekdiff Weeks.twbx 12.6 KB
Like Show 0 Likes(0)

Actions
3. Re: Week Difference

Nancy V Feb 7, 2018 3:37 PM (in response to Deepak Rai)

Hi Deepak,

Can you share the formulas used for
Index
Number of Weeks
Week Diff
Like Show 0 Likes(0)

Actions
4. Re: Week Difference

Nancy V Feb 7, 2018 3:37 PM (in response to Hari Ankem)

Hi Hari,

This is not working for me when i replace the dates with field names
Like Show 0 Likes(0)

Actions
5. Re: Week Difference

Deepak Rai Feb 7, 2018 3:39 PM (in response to Nancy V)
Like Show 0 Likes(0)

Actions
6. Re: Week Difference

Hari Ankem Feb 7, 2018 4:34 PM (in response to Nancy V)

What is the data type for the field names you are using? Are they being considered as dimensions or measures? Would you be able to attach the packaged workbook so that I can look into it?
Like Show 0 Likes(0)

Actions