Display all months in time-series data

[meboz]

Hi all,

I got a report that shows total leave taken (hours) for each month for the past 12 months, as a graph.

This graph appears for each department in my company.

Now, when the department is small, there are quite often some months where the total leave is 0, but the month does not appear on the graph, because there is no underlying data.

How can I get the 0's to appear?

Cheers

[Hack]

Is the graph created based on a query, or is it bound to a database table from which it grabs its data?

[meboz]

it accesses a bunch of CSV files directly, and this cant be avoided unfortunately