Trouble getting an average result in a text object

[Anonymous]

Hi, I'm having a hard time trying to get in a text object the same average value I get in a simple table objet.

The MTTE average result I get in the simple table object is 00:00:57 and I am not able to get it using the expression in the text object of the example I provide attached here.

Could you please help me getting the same value in the text object please?

Many thanks.

[sunny_talwar · Accepted solution]

Try this

=time(Avg({<[Classificação do Massivo] = {'Confirmado'}, Alerta -= {'$(vExcludedAlerts)'}>}CriadoIA - MTTE_SLA_Horadeinício))

[Anonymous]

It works. Thanks.