Show Weekly Device Energy by HOUR

We have this graph which shows individual devices by the hours which is great as it can be easily filtered so I can see when a device was used today.

When we change to the weekly or larger view then we see this:

Has anyone seen or created a a graph that shows the total device usage by hour in this weekly or larger timeframe? The reason is I would like to see where the main times are that a device is used. When do we USUALLY use some particular device? Happy to use any custom graph cards that could create this.