Multiseries Chart From Database With Discontinous Data

[jecourte]

I'm am working on a graph to display discontinuous data from a mysql database into a multiseries chart. I would like to use functions like the ones talked about here: http://www.fusioncharts.com/docs/PHP_DB.html , the Build Dataset and Build Categories at the end of the page. I want to use date as the horizontal bar values, but the problem is that the database records don't have data for each date. Thus, the functions are generating poorly formed XML files which can't be read by a fusioncharts graph. It's not creating the same number of nodes because each date isn't represented. Does anyone have a function which helps with this? Thanks!

[FusionCharts Support]

Hi,

 

You would need to create blank sets (<set/>) for the discontinuous data.

[Hummer]

Hi,

 

You would need to create blank sets (<set/>) for the discontinuous data.

 

Hi

 

 

 

I want the opposite to this. When there are missing data on a Line-graf, which means I use <set />, I want a line over the gap. The visitor understand the missing data if there are no dots plotted, just a linear stroke from end to end. How to do this?

[Guest Angshu]

Hi,

 

Thanks for your post.

 

Could you please send us a screenshot of your requirement?

 

Awaiting for your response.

[Hummer]

Hi,

 

Thanks for your post.

 

Could you please send us a screenshot of your requirement?

 

Awaiting for your response.

 

 

See this,

[Guest Angshu]

Hi,

 

Thanks for your post.

 

Please try the same by setting <connectNullData='1'> attribute inside the <chart> element.

 

This attribute is valid for all the line and area charts.

 

This attribute lets you control whether empty data sets in your data will be connected to each other OR would they appear as broken data sets.

 

Ref: http://www.fusioncha...d/DiscData.html

 

Please note that the above attribute will work from FusionCharts v3 onwards.

 

Hope this helps.

[Hummer]

Please try the same by setting <connectNullData='1'> attribute inside the <chart> element.

Ref: http://www.fusioncha...d/DiscData.html

Please note that the above attribute will work from FusionCharts v3 onwards.

 

 

 

Hi! Thank's. That answers why I didn't found it! I'm "learning" on free version of fusionchart. However it's good enough to know that the function are exist and only with a minor change :-).

[Guest Angshu]