Time slots/stamp analyses

[PasiNiinikoski]

Hello masters of wisdom!

I have workers that youse a handheld machine to read barcodes. From that I have data that consist following information in separate columns:

Date Timestamp (hour:min:seconds) WorkerName BarcodeRead (OK)

I would like to have solution/visual to see  how a worker has spend their working day. Would love to see breaks (more than 30 minutes) and count them together.

I have used a basic ribbon cahrt and have not edited my data at all. This is one workers day. Kinda hard to read by eyes... I could probably ignore seconds to make the graph more coherent.

Thanx for any help,

Pasi

[PasiNiinikoski]

Thanx! I have read your both links and watched the videos in them and believe this is just what I needed. Will work on it soon and test different visuals also.

[amitchandak · Accepted solution]

@PasiNiinikoski , Separate out time and date 

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

DateTime.Date([datetime])

Time = [datetime].Time
or
Time = Time(hour([datetime]),minute([datetime]),second([datetime]))

Join time with Time table and have 30 Min bucket there and date with date table

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.