In the ideal scenario, I'd be able to represent the day/wee…

In the ideal scenario, I'd be able to represent the day/week/month visually somehow, giving it a traffic light colour, so I can see an overview and potentially be able to anticipate problems in following months. But again, that's all super specific.