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
Post PatronI found the timeline issue and it is fixed. Is there any way to get labels in the bar colors?
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!
- kattlees
The 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?