Forum Discussion
Time visualizaiton (occupancy vs. availability)
Hello guys,
I have large datasets of charging of electric vehicles. Selected columns as per below:
- Location ID
- Connector ID (one Location can have multiple connectors)
- Charging from (date time)
- Charging to (date time)
What I want to achieve is to create visual that will show time utilization based on 15 minutes intervals (bins). It can be either tabular view (below) or graphical in form of project management's Gantt chart.
Example: if I have charging session that will start on 12.2.2025 at 18:02 and finish on 12.2.2025 at 19:14, I need to show it as per below:
| 12.2. | 12.2. | 12.2. | 12.2. | 12.2. | 12.2. | 12.2. | 12.2. | 12.2. | |
| Location ID | 17:30 | 17:45 | 18:00 | 18:15 | 18:30 | 18:45 | 19:00 | 19:15 | 19:30 |
| ABC-01 | (blank) or green | (blank) or green | X or red | X or red | X or red | X or red | X or red | (blank) or green | (blank) or green |
| ABC-02 | |||||||||
| ... |
Please note that charging session can last also overnight - e.g. starting from 12.2. 23:30 until 13.2. 1:15. This must be reflected in the visual.
Also there can be multiple charging sessions on one location at given time (due to multiple connectors).
What is the best way to achieve this result?
Thank you for any help!
Ivanuska