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

TIMEVALUE in Tableau

David Konjetic Mar 22, 2018 8:37 AM

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

Tableau sharing.xlsx 13.1 KB

1. Re: TIMEVALUE in Tableau

Aditya Singh Mar 21, 2018 2:59 AM (in response to David Konjetic)

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
4. Re: TIMEVALUE in Tableau

Aditya Singh Mar 21, 2018 9:25 AM (in response to David Konjetic)

Try to use Maketime function as below:
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

TIMEVALUE in Tableau

1. Re: TIMEVALUE in Tableau

2. Re: TIMEVALUE in Tableau

3. Re: TIMEVALUE in Tableau

4. Re: TIMEVALUE in Tableau

5. Re: TIMEVALUE in Tableau

6. Re: TIMEVALUE in Tableau

Actions

More Like This