custom X-axis value

[SanthoshSreshta]

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

[stephanefotso · Accepted solution]

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

[SanthoshSreshta]

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

[stephanefotso]

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!

[SanthoshSreshta]

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

[Arun_N_007]

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.

[SanthoshSreshta]

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

[stephanefotso]

each map, his own css file

[SanthoshSreshta]

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

[stephanefotso]

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