Format issue in Label

[peterderrington]

Hi, I'm having a small formatting issue with a label that i need some help with.

I have line graph which shows the Overall Median Average of the Average time of transfer which uses this expression:

Median(TOTAL AGGR([PAS Time],[PAS Date]))

For the label i want it to show the average time however when i use this expression as the label name it shows the time in decimal: =Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),))

I tried to alter it to =Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),'00:00:00')) but that doesn't help, in fact it means it doesn't show any number.

Any ideas?

[QFabian · Accepted solution]

Hi @peterderrington , please try this :

='Overall Median Average - ' & time(Median(TOTAL AGGR([PAS Time],[PAS Date])), 'hh:mm:ss')

[peterderrington]

Nope, It stays as a decimal.

If i change the '00:00:00' to 'hh:mm:ss' the number just disappears

=Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),'hh:mm:ss'))

[rwunderlich]

Why are you using the Concat() function here? I think that's incorrect.  

-Rob

[peterderrington]

That’s the way I’ve always set the expression in a label when I want it to return the value of the main expression after (or before) in the label of the legend. Happy to do it another way if there’s a better way though.

[rwunderlich]

I don't think you want to use Concat here. Did you try @QFabian suggestion as he wrote it?  I think that is correct.

-Rob

[QFabian]

Hi again @peterderrington , please send us a little data set to test, because probably the problem is in the source data time format.

Please teel me what is the value you get using this : Median(TOTAL AGGR([PAS Time],[PAS Date])

[peterderrington]

Obscurely today its working lol - amazing what a reboot will do.

Its created a new problem whereby this overall average isn't showing when you select a sub set of months but i'll look into this separately.

Thank you for all your help