11 Replies Latest reply on Jul 31, 2017 6:56 AM by Jim Dehner

Tableau problematic weekend data

Belicia Teo Jul 11, 2017 8:52 AM

Hi all,

I am currently working on a line chart from 31-Dec-15 to 30-Jun-2017 for the evolution of sales across the dates in a continuous graph. However, the weekend data (Saturday and Sunday) has some unusual corruptions and leads to sudden drops from the Weekday data. I would like to rollover all of the Friday data to the next two days (Saturday and Sunday). In other words, I want to replicate Friday (7 July 2017)'s data to Saturday (8 July 2017) and Sunday (9 July 2017). Is there anyone that can help me with this?

Thank you so much in advance!

1. Re: Tableau problematic weekend data

Jim Dehner Jul 11, 2017 9:29 AM (in response to Belicia Teo)
Hi

Have you tried
if attr( DATEPART('weekday',([Order Date]) )) < 6 then sum([Sales]) ELSE PREVIOUS_VALUE(sum([Sales]))end - note you may need to adjust the weekend value of 6 , 7 for saturday and sunday - I am in the US

it will produce this

Let me know if this helps

Jim

sat sunday sales issue.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
2. Re: Tableau problematic weekend data

Belicia Teo Jul 11, 2017 7:15 PM (in response to Jim Dehner)

Hi Jim,

Thanks for the prompt reply. The new data is what I'm looking for, but I want to transform it into a line graph. So, is it possible to have Order Date as the x-axis and the corrected sales (Pick up Friday sales) as the y-axis? Could you help me with it? Will it show the corrected weekend data?
Like Show 0 Likes(0)

Actions
3. Re: Tableau problematic weekend data

Jim Dehner Jul 11, 2017 7:20 PM (in response to Belicia Teo)

Try it. It should work. You may need to change the table calculations to
across from down but it may adjust when you place it on rows.
I will look at it,also in the morning
Jim
Like Show 0 Likes(0)

Actions
4. Re: Tableau problematic weekend data

Belicia Teo Jul 12, 2017 12:12 AM (in response to Jim Dehner)

I've tried to use the formula provided by you. It works fine on most occasions. However, when I have null data for Saturday and Sunday, the formula doesn't work for these two dates. They show '0' instead. Currently, my sales follow a zn(Lookup(sum([Sales])) because I want to replace the null data with '0'. Could you kindly advise? Thank you Jim
Like Show 0 Likes(0)

Actions
5. Re: Tableau problematic weekend data

Jim Dehner Jul 12, 2017 4:46 AM (in response to Belicia Teo)

sure
Here is the easiest way

Start with this very simple chart - just the date dimension

right click the date pill and select Show Missing Values
Then replace the calculated field for the copy of the previous vlaue

Let me know how that worked

Jim
Like Show 0 Likes(0)

Actions
6. Re: Tableau problematic weekend data

Belicia Teo Jul 12, 2017 6:50 PM (in response to Jim Dehner)

HI Jim, I could not obtain the last screenshot. Could you attach the workbook for this?
Like Show 0 Likes(0)

Actions
7. Re: Tableau problematic weekend data

Jim Dehner Jul 12, 2017 7:08 PM (in response to Belicia Teo)

What version of tableau do you have
Like Show 0 Likes(0)

Actions
8. Re: Tableau problematic weekend data

Belicia Teo Jul 12, 2017 8:57 PM (in response to Jim Dehner)

Tableau 10.1
Like Show 0 Likes(0)

Actions
9. Re: Tableau problematic weekend data

Jim Dehner Jul 13, 2017 4:27 AM (in response to Belicia Teo)
here you go
Jim

sat sunday sales issue.twbx 1.2 MB

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

Actions
10. Re: Tableau problematic weekend data

Belicia Teo Jul 31, 2017 12:27 AM (in response to Jim Dehner)

Hi Jim,

Saw the workbook. It was really brilliant. What if there is completely no data for the missing dates? Could the formula still work?
Like Show 0 Likes(0)

Actions
11. Re: Tableau problematic weekend data

Jim Dehner Jul 31, 2017 6:56 AM (in response to Belicia Teo)

I believe it will but check it out and see if it gives you the answer you need
Jim
Like Show 0 Likes(0)

Actions