How do I display text and an expression in a text object?

[#1]

'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

This for example gives me :

'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

When I would like my output of the text object to read

AVG Time: 30:00

for example...

It seems successful if I do this the other way around, e.g.

=time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss') & 'Is the avg time'

why would the order matter so much? Seems very quirky.

[er_mohit · Accepted solution]

='AVG TIME ' &  time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

hopr it helps

sorry my mistake remove that equal

[#3]

Nor working, it's not happy with the second = in the expression.