Forum Discussion
Post PatronTimeline Visual to Show Usage During the Day
It seems that the "as Timeline" custom visual gets close to what you want.
I created a dummy pbix with your sample data here
I can't say I'm completely happy with the formatting options though - I had to create a dummy column to colour the bars by room.
There are a couple of Gantt custom visuals available as well that you could play around with (Gantt and Gantt Chart By MAQ Software).
Regards,
Owen
Microsoft EmployeeThanks for sharing about this great custom visual. I have a similar problem to solve but I wasn't sure if this visual could achieve the following requirement -
I would like to show by "continuous" timeline on x-axis of a KPI metric, which has StartTime + EndTime attributes in the dataset. The tricky part is how to allocate the count across the timeline. Each record below is 1 count.
ie
StartTime EndTime
2018-01-01 08:15:51 2018-01-01 10:45:31
2018-01-01 09:45:51 2018-01-01 10:15:31
2018-01-01 13:24:51 2018-01-01 17:05:31
2018-01-01 15:17:51 2018-01-01 18:42:31
2018-01-01 07:15:51 2018-01-01 11:58:31
Final Result - a timeline chart that shows at any given time, the count. For example, at 10 am sharp, the count should be 3 (1st, 2nd, and 5th records above).
I'm not sure which visualization provides the best approach for this?
Can any of you help point me in the right direction?
Thank you!
Post PatronThe visual I used would not work for this but I did something similiar for another project and just used a bar graph. I rounded the times to the nearest 15 minute increment.
I had to create a table with all of the time values it could be, then created a summary table of other data.
- captainlaw
Do you mind sharing your solution how to round when there's a StartTime & EndTime?
- captainlaw
I'm wondering if there are other visuals that could in-take StartTime & EndTime and provides a count?
- kattlees
I am not sure
- kattlees
This one rounds down so 3:21 becomes 3:00
TimeIn = IF(MINUTE('Pre Op Times'[Time In])<30,TIME(HOUR('Pre Op Times'[Time In]),0,0),TIME(HOUR('Pre Op Times'[Time In]),30,0))
This one rounds up so 3:21 becomes 3:30
TimeOut = if(MINUTE('Pre Op Times'[Time Out])>30,TIME(HOUR('Pre Op Times'[Time Out]),59,0)+TIME(0,1,0),TIME(HOUR('Pre Op Times'[Time Out]),30,0))
- captainlaw
But the goal is not just bucket StartTime & EndTime, the goal is associate count for all times in between StartTime & EndTime. I mentioned it in my example below -
StartTime EndTime
2018-01-01 08:15:51 2018-01-01 10:45:31
2018-01-01 09:45:51 2018-01-01 10:15:31
2018-01-01 13:24:51 2018-01-01 17:05:31
2018-01-01 15:17:51 2018-01-01 18:42:31
2018-01-01 07:15:51 2018-01-01 11:58:31
Final Result - a timeline chart that shows at any given time, the count. For example, at 10 am sharp, the count should be 3 (1st, 2nd, and 5th records above).
I'm not sure which visualization provides the best approach for this?
Thanks!