1 Reply Latest reply on Aug 17, 2015 10:20 PM by Bora Beran

    Window_avg calcuating wrongly

    venkatesh.sharma

      Hi,

       

      I have a calculated field called AvgCalc

       

       

       

      CASE [Non]

           WHEN "Average" THEN Avg( ifnull([CRF  Date]- [Visit Date],ToDay()-[Non CRF ]) )

           WHEN "Max" THEN Max(Round(ifnull([CRF  Date]- [Visit Date],ToDay()-[Non CRF ]) ))

        END

       

      and now

       

      Windows_avg(AvgCalc).  But i am getting wrong datat while calculating...

        • 1. Re: Window_avg calcuating wrongly
          Bora Beran

          Can you check addressing/partitioning (compute using) settings?  You can access them from the pill context menu -> Edit Table Calculation. Window_AVG requires you to define the correct window to get the correct results. e.g. if your avg calc is at City level but you want to Average it one more time to State level then you would need to set your partitioning to State from Advanced... menu in compute using setting.