Skip to main content
Topics#Tableau Desktop & Web AuthoringAshik Ali's Question
Ashik Ali asked in #Tableau Desktop & Web Authoring
Aug 27, 2020, 6:32 PM

I want to find the retention days of the customer from the product Delivered

Hi Everyone

 

In this Dataset i have order date and delivered date. [i want to find days between the delivered date and the next order date,]

 

I want to create a new report which has to show me the Average days to purchase the next product by customer.

I want to find the retention of the customer from the product Delivered

Within how many days customers or ordering the next product from the Delivered date.(once they are happy with the delivered product then only they will purchase the next product )

 

Thanks in advance

delivered-order Date.xlsx
1 answer
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Aug 27, 2020, 6:56 PM

    Hi @ASHIK ALI​, use the formula below to get difference in days between any two dates:

     

    DATEDIFF('day', [First Date], [Second Date])

     

    The formula subtracts Second Date - First Date and gives you days between the two dates. Let me know if it was helpful.

     

    Regards,

    Sumeet

Write an answer...
0/9000