15 Replies Latest reply: Jul 11, 2011 10:47 AM by Rodrigo Almeida RSS

    Problems with Gauge Chart, Set Analysis and Networkdays

      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.