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!
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
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
@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
| rex ".*\s(?P\d+)$$$$"
| chart count by Time_Taken span=16
| sort Time_Taken
This is what I have.
@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.
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