Discontinuous Data With Date/time On X Axis

[ghmo]

Hi there

 

I've got a multi series chart (MSColumnLine3D) working well with 2 series' of data but I have an issue that I hope can be addressed.

 

My XML is attached but the issue is that within the 2 data sets that start 11th Sept and finish 23rd Sept I have no data for each series on the 19th.

 

The first set of data contains 13 values and does not have data for the 19th:

 

<category label="12-09-11"/>

<category label="13-09-11"/>

<category label="14-09-11"/>

<category label="15-09-11"/>

<category label="16-09-11"/>

<category label="17-09-11"/>

<category label="18-09-11"/>

<category label="20-09-11"/>

<category label="21-09-11"/>

<category label="22-09-11"/>

<category label="23-09-11"/>

<category label="24-09-11"/>

<category label="25-09-11"/>

 

The second second set of data has 14 values and does not contain data for the 19th and has data that is two days earlier:

 

<category label="10-09-11"/>

<category label="11-09-11"/>

<category label="12-09-11"/>

<category label="13-09-11"/>

<category label="14-09-11"/>

<category label="15-09-11"/>

<category label="16-09-11"/>

<category label="17-09-11"/>

<category label="18-09-11"/>

<category label="19-09-11"/>

<category label="20-09-11"/>

<category label="21-09-11"/>

<category label="22-09-11"/>

<category label="23-09-11"/>

 

Fusion Charts will not place an entry on the chart for the 19th without me having to code up quite a complex algorithm to work this out. Same kind of issue when the date ranges do not overlap. I have to write some fairly complex code to figure out a start date and and end date and to align the data up into each slot. I thought that there would be one to one mapping between the datasets and the labels and that FusionCharts would work this out, but I cannot see how to do this? Or that I could tell FusionCharts a start date and an end date and it would work this out, we are thinking about moving from a product called ChartDirector which did this and this seems to be the only sticking point.

 

Are there any plans for the x labels to be more date aware in the future, i.e. we can throw xml into the engine and it works all of this out?

 

Thanks

 

ghmo.

test-2.xml

Edited September 27, 2011 by ghmo

[rachgaz]

Is there anything in place now to assist with this issue?

 

thanks

 

Rach

[ghmo]

Is there anything in place now to assist with this issue?

 

thanks

 

Rach

 

I have had no reply about this, I really don't think it is solveable. I can't imagine why anyone would buy a graphing suite that does not understand dates. If you get any sort of response from this then please post here or otherwise email on the xf forum?

[Guest Bindhu]

Hi,

 

As we can see in the XML data that you have posted to us, there are totally 27 categories.

 

And FusionCharts expects that many <set> elements in each of the datasets.

 

If you provide less number of set elements in each of the dataset, then those will be mapped on to the categories from first and the last few categories will remain without data.

 

The mapping is not done on the basis of 'key-value' pair.

 

Hope this clarifies!