Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the following formula to calculate an average time expression in my chart :
=interval(avg( time),'mm')
But, the y axis values don't reflect the expression correctly. For example, if the chart value is 04:25 (mm:ss) the y - axis is showing :
04:00:00.
is there any way to format the y-axis to show mm:ss?
Many thanks,
Phil
May be this
=Interval(Avg(time), 'mm:ss')
Hi,
Thanks for your reply.
Where do I place this formula?
Where were you using this?
=interval(avg(time),'mm')
Hi, sorry there was a typo in my initial post - I already have
=interval(avg( time, 'mm:ss')
Just cant get the y -axis to show mm:ss. Or even better would be great if I can just show minutes as an integer.