8 Replies Latest reply: Jun 20, 2013 10:18 AM by test test RSS

    Displaying values in chart without Aggregation

      Hello there,

       

      I have a set of data which looks as follows.

       

      DateStockMutations
      20-06-2013700
      12-06-201375-5
      06-06-201376-1
      03-06-201377-1
      12-04-20131265
      05-03-201314-2
      15-02-201316-2
      13-02-201321-5
      30-01-201327-6
      11-01-201330-3

       

      I want to display this data in a chart, for each month.I used 'num(Month(Date)) as Month' to get the month for each record. However, when i use this month as dimension, it only shows the records which have only one record in a month.

       

      I know I should use an aggregation, cause there are more records in that month, but which one can I use to not get wrong data? So let's say only the latest date?

       

      If i use Sum() I will get a not accurate display of data.