Forum Discussion
Time slots/stamp analyses
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 , 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/
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.
2 Replies
- amitchandak
Super User
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/
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.
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.
