Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
'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.
='AVG TIME ' & time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')
hopr it helps
sorry my mistake remove that equal
='AVG TIME ' & time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')
hopr it helps
sorry my mistake remove that equal
Nor working, it's not happy with the second = in the expression.