-
1. Re: Have MAX date and want the prior date in the report as well
Shinichiro MurakamiDec 11, 2017 4:28 PM (in response to Chase Mueller)
1 of 1 people found this helpful -
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.
-
3. Re: Have MAX date and want the prior date in the report as well
Shinichiro MurakamiDec 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
-
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
-
-
5. Re: Have MAX date and want the prior date in the report as well
Shinichiro MurakamiDec 12, 2017 11:35 AM (in response to Chase Mueller)
1 of 1 people found this helpfulHi 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
-
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!