10 Replies Latest reply on Jun 12, 2013 9:30 AM by Jonathan Drummey

    Time Series at granular level

    siddhartha.siddhartha

      Hi All

       

      I have this fieild which has value like:

       

      Event Name       Amount

      X                         5

      Y                          6

      Z                          2

      X                         1

      Y                         7

      Z                          9

      I need to Plot the time sereis for the amount with days in the month.

       

      So if i select "X" the time series amount total should be sum of all the amount.

      If i Select "Y" the time series amount total should be sum of the amount for (Y+Z)

      and If i select "Z" the time series amount total should be onle Z.

       

      Please suggest.

      Thanks

       

       

      Thanks Sid