I'm currently developing a bar chart with the time on the X-axis and series which can contain empty values for that date. I'm filling the bar chart with data from a database which has a date field for the x-axis, value field for the y-axis and multiple fields for the x-axis depending on the selected series option.
Now I've encountered the following problem when working with series: (to get a view on my database open the Data.png attachment)
When I don't have an effective date for a serie (type in my case) in a month the chart will show the data incorrectly. Instead of not displaying the serie on Sep '14 the chart will still show it there (as you see in the Barchart.png indicated with the arrows). As you can see the row for type 'Procurement' for Dec '14 is also not showing.
My datasource for my bar chart looks like this:
My chart configuration looks like this:
How do I configure my datasource to skip these series on the x-axis. Is this not possible in the current version or is my datasource configured wrong?