Which chart to use to display desk occupancy

1 Answer 100 Views
Charts
Ursus
Top achievements
Rank 1
Ursus asked on 28 Jul 2023, 08:57 AM

Hi

I have the following data (just an selection):​

0: Object { myDate: Date Fri Jul 28 2023 17:43:24 GMT+0930 (Australian Central Standard Time), myTime: "17:43", myText: "NOT_OCCUPIED" }
​1: Object { myDate: Date Fri Jul 28 2023 17:32:10 GMT+0930 (Australian Central Standard Time), myTime: "17:32", myText: "OCCUPIED" }
​2: Object { myDate: Date Thu Jul 27 2023 19:50:37 GMT+0930 (Australian Central Standard Time), myTime: "19:50", myText: "NOT_OCCUPIED" }
​3: Object { myDate: Date Thu Jul 27 2023 19:33:46 GMT+0930 (Australian Central Standard Time), myTime: "19:33", myText: "OCCUPIED" }
​4: Object { myDate: Date Thu Jul 27 2023 17:41:13 GMT+0930 (Australian Central Standard Time), myTime: "17:41", myText: "NOT_OCCUPIED" }
​5: Object { myDate: Date Thu Jul 27 2023 16:50:35 GMT+0930 (Australian Central Standard Time), myTime: "16:50", myText: "OCCUPIED" }
​6: Object { myDate: Date Thu Jul 27 2023 15:47:44 GMT+0930 (Australian Central Standard Time), myTime: "15:47", myText: "NOT_OCCUPIED" }

which basically just lists when somebody is at their desk (occupied/not_occupied). This is nothing sinister - just a desk sharing situation :) - we would like visualised when the desks are being used. I would now like to have a chart that on the y axis (vertically) has two entries, occupied and not occupied. The x-axis (horizontally) has the date in 4 hour increments. the visualisation then runs from left to right and when it is occupied (eg. above 17:32 - 17:43) I would like there to be a bar shown i.e. filled, when not occupied then nothing shown. The opposite then for not occupied. Something like a stacked bar chart but only with 'gaps' if that makes sense. 

Something like this just not so ugly :) 


Anybody have any ideas which chart I could use for this

Thank you

Ursus

1 Answer, 1 is accepted

Sort by
0
Accepted
Yanmario
Telerik team
answered on 02 Aug 2023, 05:04 AM

Hi Ursus,

Thank you for the provided information about the desired layout.

The range bar chart closely resembles the screenshot:

https://www.telerik.com/kendo-angular-ui/components/charts/series-types/range-bar/

The final example from the documentation appears to be the most suitable representation for your desired use case scenario.

As an alternative to the charts, I can also propose a grouped scheduler:

https://www.telerik.com/kendo-angular-ui/components/scheduler/views/day-week/#toc-grouping-by-resources

I hope this helps.

Regards,
Yanmario
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources
Ursus
Top achievements
Rank 1
commented on 02 Aug 2023, 05:46 AM

Hi Yanmario

you are correct, the last option of the range bar could solve my problem, thank you

cheers

ursus

Tags
Charts
Asked by
Ursus
Top achievements
Rank 1
Answers by
Yanmario
Telerik team
Share this question
or