How to combine the text values in different columns and then visualize them?

[reverse]

**C1    C2  C3**
    A    X  34
    B    Y  39
    C    Z  60

Since i want to project this on a chart .. i want to combine text values of C1 and C2 and then visualize it.
Please guide

[niketn · Accepted solution]

Try the following

| eval key=C1."-".C2
| chart sum(C3) as C3 by C1 key

[reverse]

There is a date column too

C0
JAN 1
JAN 2
JAN 3