3 Replies Latest reply on Jan 11, 2019 4:45 PM by Ganapathy Palanimuthu

    Exclude specific string values from AVG LOD

    Diogo Braga

      The dataset that I am working has a similar structure to the table below. I have an AVG LOD...

       

      {fixed  [Metrics], [School Year]: AVG([Percentage])}

       

      ...but I need to exclude School Code A and B from the average calculation.

       

      How can I do it? Thank you in advance.

       

         

      School CodeMetricsSchool YearPercentage
      AMetrics 1201825
      BMetrics 1201845
      CMetrics 1201821
      DMetrics 1201878
      EMetrics 1201899
      FMetrics 1201858
      GMetrics 1201845
      HMetrics 1201878
      IMetrics 1201836
      J Metrics 1201858
      AMetrics 2201848
      BMetrics 2201822
      CMetrics 2201829
      DMetrics 2201856
      EMetrics 2201889
      FMetrics 2201865
      GMetrics 2201845
      HMetrics 2201875
      IMetrics 2201885
      J Metrics 2201865
      AMetrics 1201932
      BMetrics 1201965
      CMetrics 1201995
      DMetrics 1201945
      EMetrics 1201921
      FMetrics 1201912
      GMetrics 1201999
      HMetrics 1201958
      IMetrics 1201945
      J Metrics 1201978
      AMetrics 2201936
      BMetrics 2201958
      CMetrics 2201948
      DMetrics 2201922
      EMetrics 2201999
      FMetrics 2201958
      GMetrics 2201945
      HMetrics 2201978
      IMetrics 2201936
      J Metrics 2201958