Function today() not working

[JhonatanS]

Hi, 

I'm having problems with a average that i want do using a set analysis.

My intention was take a call open and calculate the averege of each ticket pondering by open or closed ticket and a attendant.

So i doed this:

=avg(today()-({<[USUARIO.APELIDO]={'Marcos'},[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO]={'A'}>}DATA))

Where:
DATA is a date of call open;
[USUARIO.APELIDO] is the attendant;
[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO] is about the ticket is open(A) or closed(F);

But, the function dont work. I dont now the why. I use the same argument to do anothers KPI's and succed, but this avg not.

Can you help me?

[rpennacchi]

Hi, JhonataS!

This is weird, I think the today function is causing some bug with the set analysis.

But try outter set analysis and I think it will solve your problem:

{<[USUARIO.APELIDO]={'Marcos'},[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO]={'A'}>} AVG(TODAY()-DATA)

[JhonatanS]

ok, thank you very much