Forum Discussion
freakdaddy
2 years agoRegular Visitor
Need help with stacked bar chart with variable data columns
I'm trying to represent a timeline of multiple phone agents activities. Activities are represented starting at a point to time (datetime) and have a type (available, on call, on break, etc) and a du...
freakdaddy
2 years agoRegular Visitor
The way that table was formatted by the forum distorted the data. There is a datetime column which for example should show "12/20/2023 08:00" and then there is a duration of "1". Furthermore your example is apparently grouping the activities unlike shown in my example. Agent1 has 2 activities on their timeline where they were "available" and the bar chart should match that. In total agent1 should have 5 bars in their timeline while agent2 should have 4. Also it shouldn't be a type 100% bar chart because the datetimes start and end at different times per agent. (I didn't do a good job of showing the difference in start times on my hand drawn chart)
Here is a better example chart...