-
1. Re: TIMEVALUE in Tableau
Aditya Singh Mar 21, 2018 2:59 AM (in response to David Konjetic)1 of 1 people found this helpfulCheck out the below expression:
IF [Part Order Line Shipment Priority]="URGENT" and [Packed same date]=0 and [Part Order Line Shipment Priority]<=TIMEVALUE("18:00:00") then "On Time"
else
( IF [Part Order Line Shipment Priority]="P3 NEXT DAY" then "On time,apart from exception list"
else
(IF [Part Order Line Shipment Priority]="P1 NON EU" and Packed same date]=0 and [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00") Then "On Time"
else
(IF [Part Order Line Shipment Priority]="P2 EU" and [Packed same date]=0 and [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00") then "On Time" else "Late")))
-
2. Re: TIMEVALUE in Tableau
David Konjetic Mar 21, 2018 6:20 AM (in response to Aditya Singh)Hi Aditya
this eliminates the AND function but i have still the TIMEVALUE in that is a Excel toll but not Tableau
Kind Regards
David
-
3. Re: TIMEVALUE in Tableau
Aditya Singh Mar 21, 2018 6:34 AM (in response to David Konjetic)Hi David
Can you post your data so that I can try the logic at my side.
-
-
5. Re: TIMEVALUE in Tableau
David Konjetic Mar 22, 2018 8:45 AM (in response to David Konjetic)HI Aditya
i have attached the excel file where I have the calculation in
all the collared fields are add my me and the remaining ones are from Tableau
thanks
David
-
6. Re: TIMEVALUE in Tableau
David Konjetic Apr 4, 2018 6:53 AM (in response to David Konjetic)Hi Aditya
Can you please let me know if you get anything on the data I have send to you?
Thanks
David