I don’t think you can easily get there with just charting. I think you’ll need to create separate Items for your different aggregation timeframes and then chart those. Luckily there’s a rule template on the marketplace that does the calculations for you.
If it doesn’t do everything you need, it’s at least a start you can expand on.
