Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Yes, Try like below
Dimension:
Order_Key
Measure
aggr(sum(distinct cycles),order_key)
Hi,
Yes, Try like below
Dimension:
Order_Key
Measure
aggr(sum(distinct cycles),order_key)