Splunk Search
Highlighted

How can I customize my chart with a new y-axis label?

Path Finder

Is there a way to customize the column charts label, or the y-axis?

What I want to do is create a column with the count of the field on the bar part of the chart, while on the y-axis is the percentage of that count.

index="index"
 | eval SLA_status = if(('Resolution SLA' ="Yes"),"Met","Missed")
 | timechart count by SLA_status
 | untable _time SLA_status count
 | eventstats sum(count) as Total by _time
 | eval perc=round(count*100/Total,2)
 | eval _time=strftime(_time, "%b %Y")
 | table _time SLA_status perc
 | xyseries _time SLA_status perc
Tags (4)
0 Karma
Highlighted

Re: How can I customize my chart with a new y-axis label?

SplunkTrust
SplunkTrust

You can put an alternate measure on the right, but your calculation and formatting might be complicated. Obviously, if you were doing percentage over time, then the Y number would not generally be consistent anyway, but if you are doing a static moment or period, then that could work well enough.

0 Karma
Highlighted

Re: How can I customize my chart with a new y-axis label?

Path Finder

Hi, I've updated my post with my search.

0 Karma
Highlighted

Re: How can I customize my chart with a new y-axis label?

SplunkTrust
SplunkTrust

What's your current search?

0 Karma
Highlighted

Re: How can I customize my chart with a new y-axis label?

Path Finder

@somesoni2 I've updated my post with my search.

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.