box plot and formatting values

[ali_hijazi]

Hello

got a box plot chart

the expression is sum(duration)

where duration is a number in minutes

what I want is display in the pop up the min and max values in the form of hh:mm

I tried to update the expression and put num(floor(sum(duration)/60),'00') & ':' & num(mod(sum(duration),60),'00') but this will cause the chart not to be drawn

please advise

[rubenmarin]

Hi Ali, your expression returns a string, wich can't be located in a plot char, try with this expression:

Interval(Sum(Duration)/1440, 'hh:mm')

This will return a number in the format hh:mm.

[MK_QSL]

=Interval(Time#(SUM(duration),'mm'),'hh:mm')

[ali_hijazi]

the same this will return string

[ali_hijazi]

this will return a string and the chart will fail to be drawn

[rubenmarin]

Hi Ali, this is a number with a string representation, QV will now where to locate it, you tried the expression?

[ali_hijazi]

this is where QV is locating your suggested expression

it should be at the X symbol

[rubenmarin]

And where is expected to be located? if Y-axis should be the minutes you only need Sum(Suration)...for the text reprentation in pop-up when it's different than the value you can use dual function, ie:

Dual(Interval(Sum(Duration)/1440, 'hh:mm'), Sum(Duration))

[ali_hijazi]

what i want is the following

instead of seeing 226 mins; I want to see 3:46