FusionCharts Charts For LAMP and Timestamps

[giarnz]

Hi FusionCharts Team,

I also sent this question to the FusionCharts team via their website e-mail address.

 

I just have a couple of pre-sales questions which I would appreciate if you could answer for me:

1. If I want to graph/chart data from a LAMP configuration, plotting timestamp data, can I achieve this with FusionCharts; specifically, the Free version?

2. If I am unable to plot data directly from the MySQL database or if you advise against this, what is the ideal solution to graph data from a MySQL Database?

My website records statistics for the users and uses Unix Timestamps to do this. I am hoping that I can show my visitors their statistics results for the day/week, etc. with FusionCharts but I am unsure which method to use.

 

Thanks,

Giarnz

[Pallav]

>>>1. If I want to graph/chart data from a LAMP configuration, plotting timestamp data, can I achieve this with FusionCharts; specifically, the Free version?

FusionCharts doesn't currently have a time axis. However, if your time/dates are equi-distant, you can use any of the charts to plot the same.

>>> 2. If I am unable to plot data directly from the MySQL database or if you advise against this, what is the ideal solution to graph data from a MySQL Database?

You'll need to hook FusionCharts to PHP pages to retrieve data from MySQL and then plot the same.

[masum0009]

Hi, I am new in using FusioinChart. Its a great tool must be.

 

I need to show time in 11:23:00 format instead of 11 hr 23 min . How can I archive that .

[Guest Basundhara Ghosal]

Hi,

Welcome to FusionCharts forum.

I am afraid that as of now FusionCharts does not support Time and Date as value.

However if you want to show 11hr 23min as a label then you can try it in the following way:-

<set label='11hr 23min'> inside the chart element.

Ref:-http://www.fusioncharts.com/docs/Contents/AttDesc/DataLabels.html

Hope this helps.

[masum0009]

Thank you for the solution. I am using stacked chart. It seems to me your solution work only in single series chart.

 

Please look at the url http://sandbox.infosoftbd.com/fusionchart/resource_report.php .

 

I am wanting to show here 16:00:00 than 16 hr.

[Guest Rajroop]

Hello Iftekhairul,

 

 

 

Could you please send us your XML in an attachment for this?

 

 

 

Looking forward to your reply.

[masum0009]

Here is the xml code in attachment.

data.xml

[Guest Madhumita]

Hello Iftekhairul,

I'm afraid, this will not be possible in our stacked chart.

Since the time axis is values are pre-defined to be displayed as 16hr the format cannot be changed to 16:00:00.

Your suggestions are very important to us. We have made a note of the same.

Edited October 9, 2009 by Guest