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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...