Question: Mysql - Php - Timestamps

[Josh Wegener]

Hello,

 

So, I have a database that contains the number of downloads of a file (has a MySQL timestamp).

 

I have just started using FC and I'm unsure how to get this to work. So i have a X (timestamp) and a Y (number of downloads). There will be times that have no data at all. So in one hour there could be 1000 records, and in another, 0. I still want the graph to display the dates along the bottom... (so not skipping the dates that have no data.)

 

I just want to be able to provide an X and a Y and have it graph it correctly along the X (time).

 

Thanks,

Josh W.

[Guest Angie]

Hi,

 

Welcome to FusionCharts Forum!

 

Please provide zero value to the dates that have no data in order to avoid skipping.

 

Hope this works.

[Josh Wegener]

Hi,

 

Welcome to FusionCharts Forum!

 

Please provide zero value to the dates that have no data in order to avoid skipping.

 

Hope this works.

 

It's a timestamp... So I would need to provide every hour timestamp for several days?.... There is not a better way to do this?

[Guest Angie]

Hi,

 

Welcome to FusionCharts Forum!

 

I am afraid, FusionCharts does not support timestamps, at this time.

 

We will try to implement this feature in our next release.

 

The solution we provided earlier is an alternate workaround.

 

Hope this helps.