pie graphic

[rafael5958]

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.

[sunny_talwar · Accepted solution]

Is this what you are looking for?

Dimension: =ColumnA & '|' & ColumnB

Expression: =Sum(ColumnC)

[MarcoWedel]

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