Sum values if they are Distinct based on another field_name

[Anonymous]

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_key	cycles
1234	5
1234	5
1235	4
1236	5

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

[devarasu07 · Accepted solution]

Hi,

Yes, Try like below

Dimension:

Order_Key

Measure

aggr(sum(distinct cycles),order_key)