Splunk Search

How to swap X and Y axis?

Path Finder

I have an area chart with Time_Taken on the x axis and count on the y axis and I want them to be switched, please help.

Thanks!

0 Karma
1 Solution

Esteemed Legend

Assuming that all of your values on the existing X-axis ARE NUMBERS (this is a BIG "if"), just add this to the bottom of your existing search:

| untable _time Xaxis Yaxis
| xyseries _time Yaxis Xaxis

View solution in original post

0 Karma

Esteemed Legend

Assuming that all of your values on the existing X-axis ARE NUMBERS (this is a BIG "if"), just add this to the bottom of your existing search:

| untable _time Xaxis Yaxis
| xyseries _time Yaxis Xaxis

View solution in original post

0 Karma

Influencer

@bryceweb22 Can you share your chart command?You can use untable and xyseries command. This post may help.
https://answers.splunk.com/answers/477392/how-do-i-invert-the-x-and-y-axis-in-my-chart.html

0 Karma

Path Finder

| rex ".*\s(?P\d+)$$$$"
| chart count by Time_Taken span=16
| sort Time_Taken

This is what I have.

0 Karma

Influencer

@bryceweb22 - You can simply change your visualization from column chart to bar chart, it will make time on y axis and count on x axis.

0 Karma

Path Finder

Well I have it as a area chart as of right now and I would prefer to keep it that way unless there is no way to swap their positions

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!