All column are not showing in visualisation

[singh321]

Hi,

I have one records of three columns. three columns are aggregate values- sum of column values. when i visualize it. only two column are display.

suppose i have aggregate values of three columns- Delhi, Jaipur, Chandigarh. i want to draw a pie chart where all three column values show in pie chart. but it show 2 column value only.

Thanks for the help.

[somesoni2]

Try this

your current search giving three columns (which has aggregated values)
| eval temp=1 
| untable temp City Count
| table City Count

[singh321]

which city should i use. i have a following query:
| dbxquery query="SELECT sum(DelhiTransaction) as Delhi, sum(JaipurTransaction) as Jaipur, sum(ChdTransaction) as Chandigadh FROM testDB.TranTable" connection="MySqlConnection_new"

Thanks.

[singh321]

So should i get this three aggregate values in row wise instead of column wise to visualize all three values in chart ?

[p_gurav]

Can you share sample data? and query you are using?

[singh321]

| dbxquery query="SELECT sum(DelhiTransaction) as Delhi, sum(JaipurTransaction) as Jaipur, sum(ChdTransaction) as Chandigadh FROM testDB.TranTable" connection="MySqlConnection_new"