Current Leave Balances and impact of Future Leave Bookings

Content

Hi All

The sample report attached is a visual representation of two interacting elements: Current leave balance (up to the balance calculation date) and Future Booked Leave (past the balance calculation date).

This report was created to address the issue for our managers not knowing what their team's leave liability looks like, who in their team has booked leave and what impact it has on their current leave balance all at one glance without going in and out of individual team records.

I would have preferred to combine the two charts into one and used a "secondary axis" similar to excel but this may have been a limit of ability so if anyone can suggest how to achieve that would be great.