6 Replies Latest reply on Apr 4, 2018 6:53 AM by David Konjetic

# TIMEVALUE in Tableau

Hi

I have the below formula in Excel and i need this to translate in Tableau

Excel formula

=IF(AND(G6="URGENT",U6=K6,L6<=TIMEVALUE("18:00:00")),"On Time",IF(AND(G6="P3 NEXT DAY"),"On time, apart from exception list",IF(AND(G6="P1 NON EU",U6=K6,L6<=TIMEVALUE("15:00:00")),"On Time",IF(AND(G6="P2 EU",U6=K6,L6<=TIMEVALUE("15:00:00")),"On Time","Late"))))

G6 = [Part Order Line Shipment Priority]

L6 = [Part Delivery LPN Creation Date]

U6 = [Part Order Line Pick Release Date]

K6 = [Part Delivery LPN Creation Date]

Tableau formula

IF(AND([Part Order Line Shipment Priority]="URGENT",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("18:00:00")),"On Time",IF(AND([Part Order Line Shipment Priority]="P3 NEXT DAY"),"On time, apart from exception list",IF(AND([Part Order Line Shipment Priority]="P1 NON EU",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00")),"On Time",IF(AND([Part Order Line Shipment Priority]="P2 EU",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00")),"On Time","Late"))))

I have have already translate already most of the formula but the only piece of the formula i can translate is the TIMEVALUE.

how know how i can do this?

thanks

• ###### 1. Re: TIMEVALUE in Tableau

Check 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")))

1 of 1 people found this helpful
• ###### 2. Re: TIMEVALUE in Tableau

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

Hi David

Can you post your data so that I can try the logic at my side.

• ###### 4. Re: TIMEVALUE in Tableau

Try to use Maketime function as below:

• ###### 5. Re: TIMEVALUE in Tableau

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