sr22

Plot value format

Recommended Posts

Hey guys!

 

I'm using FusionCharts to display some data from MySQL. This works fine.

My problem now is that I have to display runtimes in a scroll stacked column chart.

The format I got the data out of MySQL is a string for example: 34m3.245s.

Now I want to know how i can sum those values up to show the sum of the column at the top.

If I format the values to: mn:ss the sum includes only the minutes.

I hope you understand my problem.

Thanks.

Share this post


Link to post
Share on other sites

Hi,

For formatting number scale based on hours mins and seconds please check this documentation URL- http://www.fusioncharts.com/dev/basic-chart-configurations/number-format.html#recursive-number-scaling

Please check this sample fiddle for reference- http://jsfiddle.net/81Lkhwfb/

If you are still facing any problem, kindly share us a sample fiddle with your chart data source for our better understanding of your requirement.

Share this post


Link to post
Share on other sites
18 hours ago, Ayan Bhadury said:

Hi,

For formatting number scale based on hours mins and seconds please check this documentation URL- http://www.fusioncharts.com/dev/basic-chart-configurations/number-format.html#recursive-number-scaling

Please check this sample fiddle for reference- http://jsfiddle.net/81Lkhwfb/

If you are still facing any problem, kindly share us a sample fiddle with your chart data source for our better understanding of your requirement.

Ok Thank you very much!

 Everything works now. I was just not able to find this documentation before!

Edited by sr22

Share this post


Link to post
Share on other sites

From one problem to another.

Is there a feature where I can include the value 0?

"formatnumberscale"=> "1",
"numberScaleValue" => "60,60",
"numberscaleUnit" => ":,:",
"defaultNumberScale" => "",
"scaleRecursively" => "1",
"maxScaleRecursion" => "-1",

In my example, if there are 22 minutes and 0 seconds it shows: 22:

Or if there is exactly 1 hour and a few seconds it shows: 1:4 where I don't know if it's hours or minutes.

Unbenannt1.PNG

Edited by sr22

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now