Skip to Content
avatar image
Former Member

Crystal Report 2013 simple bar chart displaying mm:ss on Y axis

Hello guys,

i am struggling to achieve a simple bar chart displaying mm:ss in the Y axis.

I calculate in sql a datetime diff then i calulate it in seconds and on the group i calculate the average. No i would like to be able to show in a bar chart for each week the average in hh:mm:ss or mm:ss.

Even if i convert the average time in the following way:

time(Average ({@seconds}, {@weeknumber}) / 86400)

the resulting bar chart has all values=1. Tried also to play with the chart but nothing.

or if i convert in a string like the following:

"0"+ToText(floor(Average ({@seconds}, {@weeknumber})/60,1), 0)+":"+totext(Average ({@seconds}, {@weeknumber}) mod 60,0)

i cannot achieve the goal.

If can you put on the right direction it would be really great.

Thanks in advance

Lucaimagechart-not-diplaying-seconds.jpg

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers