topic Function today() not working in App Development

Function today() not working

JhonatanS — Thu, 09 Mar 2023 18:39:44 GMT

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?

Re: Function today() not working

rpennacchi — Thu, 09 Mar 2023 21:26:53 GMT

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)

Re: Function today() not working

JhonatanS — Wed, 15 Mar 2023 13:31:31 GMT

ok, thank you very much