Splunk Search

How to swap X and Y axis?

bryceweb22
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

woodcock
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

woodcock
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
0 Karma

Vijeta
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

bryceweb22
Path Finder

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

This is what I have.

0 Karma

Vijeta
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

bryceweb22
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
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

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

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...