5 Replies Latest reply: Nov 30, 2012 7:54 AM by Gysbert Wassenaar RSS

    Min date per attribute & Total Sum in graph

      Hi all,

       

      Question 1)

      Is there and way to use Total Mode Sum as a dimention in a graph.

      For example illustrate the sum of these specific values in comparison with all the other values, is it possible in a pie chart??

       

      Question 2)

       

      I have a table like this:

      Test dateSensor StatusUnit Serial
      28/11/2007 16:47Fail1787
      28/11/2007 16:53Fail1787
      28/11/2007 16:54Fail1787
      05/12/2007 14:39Fail1795
      05/12/2007 14:42Pass1795

       

      My desired table would look like this

      Test dateSensor StatusUnit Serial
      28/11/2007 16:47Fail1787
      05/12/2007 14:39Fail1795

       

      So what i have to do is to select the first date per Unit serial.

      Any suggestion ideas are welcome.Thank you in advance.