Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
peterderrington
Creator II
Creator II

Format issue in Label

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?

 

1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

Hi @peterderrington , please try this :

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

QFabian

View solution in original post

7 Replies
QFabian
Specialist III
Specialist III

Hi @peterderrington , please try this :

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

QFabian
peterderrington
Creator II
Creator II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

peterderrington
Creator II
Creator II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist III
Specialist III

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])

QFabian
peterderrington
Creator II
Creator II
Author

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