3 Replies Latest reply on Jan 27, 2014 5:51 PM by malou.puyod

14) by 7?

malou.puyod Jan 27, 2014 2:53 AM

I created a calculated field to display my date like this 01/27/14 :

STR(DATEPART('month',[DATE])) + "/" + STR(DATEPART('day',[DATE])) + "/" + STR(DATEPART('year',[DATE]))

My x-axis is Date which has a format mentioned above BUT my problem is the dates should increment by 7 in which start date is always every Monday. How can I do this?

1. Re: How can I increment the date (format: 01/27/14) by 7?

kettan Jan 27, 2014 3:15 AM (in response to malou.puyod)
This calculations adds 7 days to the date:
.
date(dateadd('day', 7, [date]))
.
The reason I also used DATE was to convert it from DATETIME to DATE and thus save time in formatting it without time.
.
Instead of a string calculation, you could probably just format the date using the format mm"/"dd"/"yy :

Workbook Version: 8.1

thread 138183 How can I increment the date - format 012714 - by 7.twbx 3.9 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How can I increment the date (format: 01/27/14) by 7?

kettan Jan 27, 2014 6:02 AM (in response to malou.puyod)

My x-axis is Date which has a format mentioned above BUT my problem is the dates should increment by 7 in which start date is always every Monday. How can I do this?

I think this is what you need:

Right-click Axis (for date) > Tick Marks > Fixed

Every 1 Weeks
Tick Origin 27-01-2014

I think your date axis needs to be continuous.
Like Show 1 Likes(1)

Actions
3. Re: How can I increment the date (format: 01/27/14) by 7?

malou.puyod Jan 27, 2014 5:51 PM (in response to kettan)

Thanks. Got it!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How can I increment the date (format: 01/27/14) by 7?

1. Re: How can I increment the date (format: 01/27/14) by 7?

2. Re: How can I increment the date (format: 01/27/14) by 7?

3. Re: How can I increment the date (format: 01/27/14) by 7?

Actions

More Like This