5. Missing dates

This example shows how we can use Merged charts to show missing days such as weekends or other non-working days. Firstly, we’ve created a chart that shows the developer time spent for a period of 3 months. However, there are some non-working days in this date range and we want to be able to see those on the Merged chart. To do this, we’ve added a second chart that shows every date, including non-working days, but doesn’t contain any data. When we combine the two charts into a Merged chart we’ll be able to see where all the non-working days are.

To create a chart that uses empty dates - create an object in the data source that doesn’t contain any data and combine with a date object.

When these two charts are combined together, the X Axis of the Merged chart will display gaps where there is missing data. Using a date range Category Object filter will then work without having to do anything else to either chart - the date range filter will filter the date ranges on both charts and return both the empty dates and the non empty dates.

Please take a look here for step by step instructions on how to recreate this example.