Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transit Time Benchmark

Hi All,

 

I am trying to create a dashboard which compares actual Transit time against a benchmark transit time per lane. 

 

Actual Transit time from Kobe to Los Angeles, CA= 18 days

Benchmark Transit time Kobe to Los Angeles, CA= 15 days

 

Actual Transit time from Nansha to Seattle, WA= 25 Days

Benchmark Transit time Nansha to Seattle, WA=31 Days

 

Instead, my benchmark times are showing the same time for all of the ports. 

 

Benchmark Transit time Nansha to Seattle, WA=31 Days

Benchmark Transit time Nansha to Los Angeles, CA=31 Days

Benchmark Transit time Nansha to Long Beach, CA=31 Days

Benchmark Transit time Nansha to Chicago, IL=31 Days

 

It applying the average of all the ports collectively. My tables are linked based on a Origin&PortofArrival key. I have a table of all the actual data and another table of strictly benchmark data

  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured it out. Silly mistake. I forgot to set the cross filter direction to both

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey so I tried that, but the relationship is not simply one to one. 

       

      Many origins can go to one Port of arrival. Tokyo to LAX, Nansha to LAX, PASIR GUDANG to LAX, etc. Because of this, the LOOKUPLVALUE function will not work.

       

      Below is a screenshot of what i have. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        I figured it out. Silly mistake. I forgot to set the cross filter direction to both