Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm problem with a formula into a gauge chart, here is:
=avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#=vInicio)<=$(#=vFim)"} > } (networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )
I want to know the average in the last 90 days but using the networkdays.
"allholidays" is a variable with all holidays in my country.
This formula give "no data value" but I don't know why.
If I use:
=avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#=vInicio)<=$(#=vFim)"} > } ALL (networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )
...works fine.
But I cannot use ALL.......
What I can to do?
Anybody can help me, please?
Thanks,
Rodrigo.
Hi,
I did, but it runs the same.
= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } (SLADiff) )
SLADiff is the field created in load script.
But... there is no data value.
If I use:
= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } ALL (SLADiff) )
works fine, but I cannot use ALL in that expression...
I really dont know what to do.
Thanks,
Rodrigo.
Hi,
Can you please provide the qvw file.
Regards,
Kaushik Solanki
Hi, Rodrigo.
Do you know why it works with All? This would ignore selections and dimensions in a chart?
Are you using any dimension on the gauge?
Does it work with the 1 instead of $?
avg ( {1< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } (SLADiff) )
(... a lot of questions to try to better understand your problem)
Regards,
Erich
Hi,
I cannot send the file now because there is a lot of customer's data.
But..... I 'd tried a test...
If I use the expression without the agregation of dates in set analysis, it works fine:
= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"}/> }
(networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )
I think the problem is in the agregation
Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"}
However I need to used that to agregate the status (EstadoReport field) and agregate the last 90 days.
What can I do??
Thanks,
Rodrigo.
Hi Erich,
I'm not using dimensions.
I'm just using that expression.
I need to know the average count of days (it is a diference date between Update Date and Creation Date), agregate by Status and las 90 days.
But I really dont know why does not work without ALL function....
Do you have an idea?
Thanks,
Rodrigo.
Friends!
I won this chalenge.
Thanks Kaushik and Erick.
Thank you for your support.
Best regards,
Rodrigo.