Splunk Search

How can I create a graph with this table to my simple specifications?

brillio2017
New Member

Hello,
Using search query, I am able to create a table having two columns as shown below.

Col_1              Col_2
-----              -----
1993               25
2000               60
2015               23
2017               10

I need to make a simple column chart/bar chart with Col_1 on x-axis and Col_2 on y-axis.
Can anybody let me know the solution for this question.

0 Karma

niketn
Legend

Your output should work out of the box as Col_1 on x-axis and Col_2 on y-axis of a Column Chart.

<YourBaseSearch>
| table Col_1 Col_2
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

brillio2017
New Member

I am able to get the table after query :

| table Col_1 Col_2

But not able make column chart/bar chart.

0 Karma

niketn
Legend

Is this is dashboard or search?

If this is dashboard you need to Edit Dashboard and change the Visualization by choosing Column Chart. Refer to some of the steps to create dashboard for your reference: https://docs.splunk.com/Documentation/Splunk/latest/SearchTutorial/Createnewdashboard

If this does not work you will have to paste a screenshot of what you have.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

3no
Communicator

Try this after your search :

| xyseries Col_1 Col_2 Col_2 

3no

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...