topic Re: All column are not showing in visualisation in Dashboards & Visualizations

All column are not showing in visualisation

singh321 — Thu, 26 Apr 2018 10:46:18 GMT

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.

Re: All column are not showing in visualisation

p_gurav — Thu, 26 Apr 2018 12:23:08 GMT

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

Re: All column are not showing in visualisation

somesoni2 — Thu, 26 Apr 2018 14:26:37 GMT

Try this

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

Re: All column are not showing in visualisation

singh321 — Fri, 27 Apr 2018 05:43:34 GMT

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

Re: All column are not showing in visualisation

singh321 — Fri, 27 Apr 2018 05:54:17 GMT

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.

Re: All column are not showing in visualisation

singh321 — Fri, 27 Apr 2018 06:23:28 GMT

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