Dashboards & Visualizations

All column are not showing in visualisation

singh321
New Member

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.

Tags (1)
0 Karma

somesoni2
Revered Legend

Try this

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

singh321
New Member

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.

0 Karma

singh321
New Member

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

0 Karma

p_gurav
Champion

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

0 Karma

singh321
New Member

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...