Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, I have this situation:
columnA ColumnB ColumnC
A 10
B 20
C 50
John D 10
John D 30
Paul E 80
I need a pie graphic with column A as a dimension and sum the Column C values when equals. Like:
columnA ColumnB ColumnC
A 10
B 20
C 50
John D 40
Paul E 80
How can I do that? When I select the blank space on column A it shows only one element on graphic instead of the three.
Is this what you are looking for?
Dimension: =ColumnA & '|' & ColumnB
Expression: =Sum(ColumnC)
Is this what you are looking for?
Dimension: =ColumnA & '|' & ColumnB
Expression: =Sum(ColumnC)
Hi,
another solution could be:
LOAD *,
Dual(ColumnA,AutoNumberHash128(ColumnA,ColumnB)) as ColumnAB
INLINE [
ColumnA, ColumnB, ColumnC
" ", A, 10
" ", B, 20
" ", C, 50
John, D, 10
John, D, 30
Paul, E, 80
];
hope this helps
regards
Marco