Skip to Content

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

Jul 10, 2017 at 10:27 AM


avatar image
Former Member

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers