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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...