Plot value format

[sr22]

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.

[Ayan Bhadury]

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.

[sr22]

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 September 13, 2017 by sr22

[Ayan Bhadury]

Good to know that the problem was solved.

[sr22]

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.

Edited September 14, 2017 by sr22

[Ayan Bhadury]

Hi,

Please note scaling the data plot values in  hh :mm :ss format is not possible natively, however, as a workaround, you could achieve this format number feature of FusionCharts.

Please check the sample fiddle for reference -http://jsfiddle.net/nrtmpqmu/