12 Replies Latest reply on Dec 7, 2018 1:23 PM by Yijing Lu

    Normalize filtered data using LOD functions

    Yijing Lu

      Hi all,

       

      I am trying to normalize a column data to 0-1 range, but encountered some problem with filtered data. I used the LOD function to create the normalized data for variable "Accessibility" for the rows that have the same Origin Zone. See below.

      acc1.png

      And it doesn't show any error. However, when I dragged the Origin Zone to the Filter and Norm_acc to the Color. It gave me the error. See below.

      acc2.png

      It seems that I couldn't normalize the Accessibility based on the filtered data. Please see the attached workbook. Could some one help me out of this?

       

      Help is really appreciated.


      Yijing