topic Re: custom X-axis value in Splunk Search

custom X-axis value

SanthoshSreshta — Mon, 28 Sep 2020 19:58:29 GMT

Hi. My aim is to get custom text in X-axis instead of actual values.

I have used a query to generate column chart
sourcetype="Customer_Churn"
| eval CHURN = if(CHURN="1",1,0)
| stats sum(CHURN) as total_churn by PLACEMENT

the values of PLACEMENT are 0 and 1 which indicated Rural and Urban respectively.
I need Rural and Urban instead of 0 and 1 on the X-axis. Is it possible with splunk.??

Thanks in advance.
Santhosh

Re: custom X-axis value

stephanefotso — Mon, 28 Sep 2020 19:54:39 GMT

Try this:

sourcetype="Customer_Churn"
| eval CHURN = if(CHURN="1",1,0)
| stats sum(CHURN) as total_churn by PLACEMENT| replace 0 with "Rural" in PLACEMENT | replace 1 with "Urban" in PLACEMENT

Re: custom X-axis value

SanthoshSreshta — Fri, 15 May 2015 13:32:15 GMT

Thank you for the quick response.
Doesn't they be placed right middle of it. like as i showed in the above image

Re: custom X-axis value

stephanefotso — Fri, 15 May 2015 13:50:11 GMT

I don't know, but i think it is possible.
Thanks!

Re: custom X-axis value

stephanefotso — Mon, 18 May 2015 22:31:02 GMT

Hi! Is there any problem with the query ? I think the question was accepted. What happen again? OK Concerning the configuration of your chart, check here,
http://docs.splunk.com/Documentation/Splunk/latest/Viz/ChartConfigurationReference

I Think it may help
Thanks!

Re: custom X-axis value

SanthoshSreshta — Wed, 20 May 2015 04:38:42 GMT

Hi @stephanefotso I have used
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
but there is no change in it. Is that the tag I should use to get or there is any other tag.?
I am unaware of this. please help me

Re: custom X-axis value

Arun_N_007 — Wed, 20 May 2015 05:06:05 GMT

Hi Santhosh,

I dont think it is possible with Splunk default chart (JS Chart). If you want to change you might need to play with the CSS part of it or you can implement D3 Bar chart in Simple XML.

Re: custom X-axis value

SanthoshSreshta — Wed, 20 May 2015 05:08:40 GMT

okay fine. can we do for each map or the same CSS will effect all charts and maps.?

Re: custom X-axis value

stephanefotso — Wed, 20 May 2015 21:26:44 GMT

each map, his own css file

Re: custom X-axis value

SanthoshSreshta — Thu, 21 May 2015 04:36:22 GMT

Can you please share me, How to add CSS files and HTML files, I am reading many post. lot many people are doing lot many things from HTML and CSS. I didn't get anywhere ; how to add such things.?

here is my post link
link for the post