Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have following simple table (see below). In my report I need to count quantity of lines. So in Order 1 I have 2 lines and in Order 2 I have 5 lines but SKU 1 has 3 records. In my report my result should be 7 line.
When I use "count" I recieve 9 lines. When I use cound count (distinct(...) I recieve 5.
Could you please support me? My result should be 7 because in ORDER 1 I have 2 lines and for ORDER 2 I have 5 lines
Order | Line | |
ORDER 1 | SKU 1 | 1 |
ORDER 1 | SKU 2 | 2 |
ORDER 2 | SKU 1 | 1 |
ORDER 2 | SKU 1 | 1 |
ORDER 2 | SKU 1 | 1 |
ORDER 2 | SKU 2 | 2 |
ORDER 2 | SKU 3 | 3 |
ORDER 2 | SKU 4 | 4 |
ORDER 2 | SKU 5 | 5 |
My code is:
o:
load * inline [
Order,sku, Line
ORDER 1, SKU 1, 1
ORDER 1, SKU 2, 2
ORDER 2, SKU 1, 1
ORDER 2, SKU 1, 1
ORDER 2, SKU 1, 1
ORDER 2, SKU 2, 2
ORDER 2, SKU 3, 3
ORDER 2, SKU 4, 4
ORDER 2, SKU 5, 5
];
Ofter load the sample table with Order as dim and count(Order) as expresion
shows:
total: 9
order 1: 2
order 2: 7
For me it's correct 🙂
maybe
Count(Distinct Order&Sku)
?