How to create a date out that shows days, hours, minutes, seconds

Question & Answer
,
6

HI @jfant001 ,

Thanks for your query. Before going to create your calculated field as DD:HH:MI:SS you need to first create your date difference that is Call Start Time and Call End Time duration as sec.

Step -1

dateDiff({Call Start Time},{Call End Time}, ‘SS’)

Step - 2

Use this below formula

image
image804×193 6.05 KB

The yellow highlighted area is the field name of your date duration between start time & end time.

Note - You can not plot this data on KPI visual type.

If you want to Create DD:HH:MM:SS format for line level then just go to the Demo Central and see the detailed analysis it is very easy to understanding all the calculation.

DemoCentral (learnquicksight.online)

If you feel any difficulties please revert back .

Thanks & Regards
Biswajit Dash

2 Likes