0 Replies Latest reply on Nov 27, 2007 5:06 AM by

    Using filterFunction on an ArrayCollection

      Hello,

      I have an ArrayCollection of n columns.
      The data is identified by col1 and is filled like this:

      col1 col2 col3 ...
      a int int
      a int int
      a int int
      b int int
      b int int
      c int int
      c int int
      c int int
      ...

      I want to graph (using Charting) this collection in such a way that each distinct value of col1 is a line, and then filter across the other cols.

      So for example in this case I would have 3 lines, each representing 'a' 'b' and 'c', and then I could apply the filter 'col2'.
      I am aware of the filterFunction but am unsure how to achieve this specifically. This is similar to the pivot function of Excel, where one would be pivoting upon col1.

      Any help would be appreciated.
      Thanks!

      edit: I should add that the values of 'name' are unknown but sorted into blocks as per the example.