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.
Try this
your current search giving three columns (which has aggregated values)
| eval temp=1
| untable temp City Count
| table City Count
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.
So should i get this three aggregate values in row wise instead of column wise to visualize all three values in chart ?
Can you share sample data? and query you are using?
| dbxquery query="SELECT sum(DelhiTransaction) as Delhi, sum(JaipurTransaction) as Jaipur, sum(ChdTransaction) as Chandigadh FROM testDB.TranTable" connection="MySqlConnection_new"