CODEWITHSUNDEEP
tableau-api
mandmi
mandmi

Reputation: 69

How to calculate durarion from date time entry dates?

I have 4500000 rows of data of workers processing units which is the following format: entry date in DD.MM.YYYY HH:MM:SS format and quantity

This is the raw data for one worker:

ENTRY_DATE          QUANTITY
08.07.2018 19:09    1
08.07.2018 19:09    1
08.07.2018 19:09    1
08.07.2018 19:09    1
08.07.2018 19:09    2
08.07.2018 19:09    4
08.07.2018 19:09    8
08.07.2018 19:09    11
08.07.2018 19:10    1
08.07.2018 19:10    1
08.07.2018 19:10    1
08.07.2018 19:10    2
08.07.2018 19:10    3
08.07.2018 19:10    3
08.07.2018 19:10    4
08.07.2018 19:10    8
08.07.2018 19:10    8
08.07.2018 19:10    2
08.07.2018 19:10    7
08.07.2018 19:10    1

Is it possible to get of how long worker worked from this data? I know the raw data example is bad since it shows only one minute. But it goes on for whole day and multiple days etc.

Worker names are specified in separate column.

Upvotes: 0

Views: 75

Answers (1)

akshay
akshay

Reputation: 777

In tableau, according to the data that is given, you can Create Calculated Field with the expression { FIXED [Name],DATE([Entrydate]): DATEDIFF('minute',MIN([Entrydate]),MAX([Entrydate])) } (This will return the difference in Minutes. You can change it to hour,day, etc) and drag WorkerName dimension and the new calculated field in the Rows section. Then change the calculated field to Discrete in Rows section.

Upvotes: 1

Related Questions