6 Replies Latest reply on Dec 12, 2017 11:40 AM by Chase Mueller

Have MAX date and want the prior date in the report as well

Chase Mueller Dec 11, 2017 4:11 PM

I am trying to create a view that includes the most current Plan Date, as well as the previous Plan Date (Next to Last Value). Have tried Previous Value and MAX -1, among a number of other things that I read on the forum. Nothing allows me to include the previous Plan Date and run a calculation on the difference. Hoping someone out there can help me. I have included the packaged workbook with the main view on the first tab, and something I tried on the 2nd tab to achieve the Next to Last Value, but I cannot manage to bring them together the way I want. Thanks.

Plan Date Performance_Test.twbx 9.8 KB

1. Re: Have MAX date and want the prior date in the report as well

Shinichiro Murakami Dec 11, 2017 4:28 PM (in response to Chase Mueller)
HI Chase.

Assuming Style ID is unique, you can use below LODs.

Regards,
Shin

Plan Date Performance_Test_SM_10.1.twbx 10.0 KB

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

Actions
2. Re: Have MAX date and want the prior date in the report as well

Chase Mueller Dec 11, 2017 4:39 PM (in response to Chase Mueller)

Thanks Shin! That did the trick. This is an awesome first experience using the forum.
Like Show 0 Likes(0)

Actions
3. Re: Have MAX date and want the prior date in the report as well

Shinichiro Murakami Dec 11, 2017 4:46 PM (in response to Chase Mueller)

HI Chase,

You are very welcome and I am glad that you like forum as the first experience.
I hope you keep enjoying this forum and learn Tableau.

Regards,
Shin
Like Show 0 Likes(0)

Actions
4. Re: Have MAX date and want the prior date in the report as well

Chase Mueller Dec 12, 2017 11:29 AM (in response to Shinichiro Murakami)
Shin - now that I added another PO, the LOD for 2nd Last Plan Date (named this "Last Date by PO Number") is not working. Returns the 2nd Last Date by PO overall. I used PO Number for the LOD equation because it is unique for each shipment. I have re-attached the workbook for your review.

Plan Date Performance_Test.twbx 16.1 KB
Like Show 0 Likes(0)

Actions
5. Re: Have MAX date and want the prior date in the report as well

Shinichiro Murakami Dec 12, 2017 11:35 AM (in response to Chase Mueller)
Hi Chase,

If PO number is unique, you are OK with adding PO NUmber after Fixed.

If some combination like "style" x "Po number" creates unique date, you should add all those fileds between "fixed" and ":"

Regards,
Shin

Plan Date Performance_Test_SM_10.1_V2.twbx 16.1 KB

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

Actions
6. Re: Have MAX date and want the prior date in the report as well

Chase Mueller Dec 12, 2017 11:40 AM (in response to Shinichiro Murakami)

Adding the [PO Number] to the "2nd to Last Date" equation did the trick. Thanks for your speedy assistance!
Like Show 0 Likes(0)

Actions