Skip to main content
Topics#Tableau Desktop & Web AuthoringNaveen Reddy's Question
Naveen Reddy (Cisco) asked in #Tableau Desktop & Web Authoring
Dec 14, 2018, 6:53 PM

Find the POs Delivered in the next date and tag to the current date

Hi All,

 

I have a data like below

 

File DatePO NumberStatus14-Nov-18PO1Not Delivered14-Nov-18PO2Not Delivered14-Nov-18PO3Not Delivered14-Nov-18PO4Delivered15-Nov-18PO1Delivered15-Nov-18PO2Delivered15-Nov-18PO6Not Delivered

 

I Need the Output Like below

 

File DateCount of PO Number Only Not DeliveredCount of PO Delivered Next Day (PO Which is In Next Day ) 14-Nov-18322 because PO1 and PO2 is Not Delivered on 14 Nov, Delivered in Next day so need to compare the PO In the 14 Nov File date with 15 Nov and Show the count of PO Delivered15-Nov-1810

 

I want to count the PO's in the One date and compare that PO's with Next date and check the status if it is delivered. Tag that counts to the current date

 

Hope this helps

 

I unable to think thru where I am missing the logic.

 

Shinichiro Murakami Kindly help me on this

3 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Dec 14, 2018, 7:28 PM

    Hope this helps.

    Sample is not big enough, then you may need modify something, but basic concept is here.

    Hope this helps.Sample is not big enough, then you may need modify something, but basic concept is here. I want to avoid using Table calculation in general.I used union instead to shift one day.

     

    pastedImage_2.png

     

    I want to avoid using Table calculation in general.

    I used union instead to shift one day.

     

    pastedImage_3.png

     

    pastedImage_4.png

     

    pastedImage_5.png

     

    pastedImage_6.png

     

    pastedImage_7.png

     

    Thanks,

    Shin

Write an answer...
0/9000