topic Re: Interchange timechart axis in Dashboards & Visualizations

Interchange timechart axis

Allampally — Tue, 29 Sep 2020 20:29:38 GMT

Hi,

I want to interchange axis in timechart graph. For eg. for my chart, X-axis is requests_per_sec and Y-axis is _time.
I want to interchange these axis i.e. X-axis as _time and Y-axis as requests_per_sec. How can i do that ?

Re: Interchange timechart axis

deepashri_123 — Tue, 29 Sep 2020 20:29:43 GMT

Hey Allampally,

You can try using this:
untable requests_per_sec _time | xyseries _time requests_per_sec

Or refer this link:
https://answers.splunk.com/answers/1286/is-there-a-way-to-get-a-result-that-looks-like-timechart-but-with-the-axes-reversed.html

Let me know if this helps!!

Re: Interchange timechart axis

manish_singh_77 — Tue, 29 Sep 2020 20:29:46 GMT

pls use this and let me know if it works for you:

chart count over _time by requests_per_sec

Re: Interchange timechart axis

Allampally — Wed, 18 Jul 2018 04:42:03 GMT

No,, it is not giving the output which i want

Re: Interchange timechart axis

Allampally — Tue, 29 Sep 2020 20:30:28 GMT

seems, something is missing in xyseries,, it is expecting one more field. Not sure what to enter there apart from _time and requests_per_sec