2 Replies Latest reply: Apr 21, 2014 1:52 PM by Norman Livermore RSS

    Using 2 dimensions and RangeSum in a Line Chart

      Struggling with this just now.


      I have data which represents defects (%) accumulating by time for several divisions and wanted to graph a trend line.


      I have been able to produce a pivot table with the data desired but can not graph.

      First Dimension (outer) is the Division, Second Dimension (inner) is the number of days into a process.  One expression...

           rangesum(above(sum(defects),0,rowno())) / rangesum(above(sum(products),0,rowno()))


      I have been successful by using multiple expressions each applying a set that limits the data to a single Division but this is not very flexible and challenging for representing more than just a very few Divisions.


      Any thoughts?


      Ideally I would produce a Line Graph with several lines each representing a different Division and plotting a defect % accross days. Really want to allow the user to select a subset of Divisions.