1 Reply Latest reply: Jun 19, 2017 3:47 AM by Devarasu R RSS

    Sum values if they are Distinct based on another field_name

    Toby Cameron

      Hello,

       

      I'm trying to find the best place to find the correct syntax definitions for chart functions in the visualization level.

       

      What I'm trying to do is Sum the number of values if for each distinct line of data, that is:

       

      order_keycycles
      12345
      12345
      12354
      12365

       

      The expected results for this data would be a total of 14 cycles.

       

      I could count distinct cycles but I would only get 9 cycles. I need to count cycles based on the distinct(order_key), is this possible?

       

      Cheers,

      Toby