Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
ok, thank you very much