Dividing time records for hours

[#1]

Hello,

My registration system check in / out records the date / time of arrival and departure of the worker. I intend to find out how many workers there are per hour, to evaluate it. My excell dumps me so

As I can do to present it in this way. Thank you

[sunny_talwar]

Create a new Field during your load your data:

LOAD AllOtherFieldNames,

          Hour([Fecha Creacion]) as Hour

FROM Source;

and now use Hour as your dimenion

[swuehl]

I assume you want to get a count of the workers also for the time between check in and check out, when they are present at work.

Here is a similar discussion with some different approaches:

How to count how many people were/are in the building??

Also look at the tech doc written by Henric:

IntervalMatch and Slowly Changing Dimensions

[#4]

Hi, nice to meet you

Thanks for the information. i´ll to study it

Best regards

[DavidFoster1]

Look at WHILE and IterNo() options in the LOAD statement. Using those you could create a table with a record for each person, for each hour they are checked in. That way it is very simple to filter on the hour to see who was checked in at that time.