Calculate Duration Between Two Dates in Tableau in (HH:MM:SS)

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024

ความคิดเห็น • 9

  • @georgedossantosaraujo2611
    @georgedossantosaraujo2611 ปีที่แล้ว +1

    Very good video, a question how do you show this duration longer than 24 hours?

  • @jeremiahakinlabi7232
    @jeremiahakinlabi7232 7 หลายเดือนก่อน +1

    Very clear, thank you. The question is how you'd calculate total or average time now it's been changed to string

    • @carminagaalex
      @carminagaalex 2 หลายเดือนก่อน

      same question

  • @TH-vw4qn
    @TH-vw4qn ปีที่แล้ว

    Very clear and concise. Thank you!

  • @UmeshYadav-lg6cy
    @UmeshYadav-lg6cy ปีที่แล้ว

    Hello Thanks for this, How to calculate time duration between two dates excluding holiday and weekends. Please help

    • @DSCOVRAnalytics
      @DSCOVRAnalytics  ปีที่แล้ว

      Hi Umesh, check out the following blog: www.theinformationlab.co.uk/2017/05/22/calculate-working-days-dates-tableau/

    • @UmeshYadav-lg6cy
      @UmeshYadav-lg6cy ปีที่แล้ว

      Hi Thanks,

  • @carlagasparetto1047
    @carlagasparetto1047 ปีที่แล้ว

    how can I calculate duration between days? In your example the duration is in the same day...

    • @DSCOVRAnalytics
      @DSCOVRAnalytics  ปีที่แล้ว

      Hi Carla, are you looking for duration between two dates in days? For instance if he had two date periods like ship date (23-06-2023) and order date (20-06-2023) we could use datediff('day', [order date], [ship date]) to calculate the total difference in days.