Splunk Search

Scale Y axis for timechart

kkao00
Engager

Hi,

I run a real time query in splunk search during load testing, and it comes out like this:

http://picpaste.com/pics/splunk_timechart-vCg4doz1.1347913377.PNG
alt text

I'd like to be able to divide the y-axis by 60. So instead of 200/400/600/800 it'd be 3.33/6.66/10/etc. Can this be done?

The query is sourcetype="access-prod-wcs" useragent = "CLOUDTEST-SOASTA" OR useragent = "Lr-Perf" OrderProcessCmd | timechart count by sitefamily

Thanks

Tags (3)
0 Karma
1 Solution

melting
Splunk Employee
Splunk Employee

I think you just want to eval count to what you want

ex:
... | eval(count(source)/60)

So your search:
sourcetype="access-prod-wcs" useragent = "CLOUDTEST-SOASTA" OR useragent = "Lr-Perf" OrderProcessCmd | timechart eval(count(sitefamily)/60) by sitefamily

Other timechart commands:
CommonStatsFunctions

View solution in original post

melting
Splunk Employee
Splunk Employee

I think you just want to eval count to what you want

ex:
... | eval(count(source)/60)

So your search:
sourcetype="access-prod-wcs" useragent = "CLOUDTEST-SOASTA" OR useragent = "Lr-Perf" OrderProcessCmd | timechart eval(count(sitefamily)/60) by sitefamily

Other timechart commands:
CommonStatsFunctions

kkao00
Engager

Thank you!!!

0 Karma

melting
Splunk Employee
Splunk Employee

I edited my answer. I had an ever simplified version of your search. Take look at my edited answer.

kkao00
Engager

Didn't seem to work...Shows the same chart as the original query.

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...