topic Re: How to change the Y-axis display data labels on a scatter plot? in Reporting

How to change the Y-axis display data labels on a scatter plot?

faisalchohan — Wed, 13 Apr 2022 02:29:52 GMT

Hi Splunk Members,

I am relatively new to splunk and I wanted to ask a very basic question.

I would like to find out "How can I change the Y-axis display data labels on a scatter plot without comprising the 1 to 3 scale ?

from:

| eval Alert_Level = case(Alert_Level = "Very Poor", 1, Alert_Level = "Poor", 2, Alert_Level = "Fair" , 3 )

| table Xaxis Yaxis Alert_Level

This is incorrect as this plot thinks it is a string rather then number.

| eval Alert_Level2 = case(Alert_Level = 1, "low", Alert_Level = 2, "medium", Alert_Level = 3 , "high" )

| table Xaxis Yaxis Alert_Level2

or else i was trying the below but not sure if i am doing it in a best way

HTML Source:

<option name="charting.chart.showDataLabels">high</option>
<option name="charting.axisTitleY.visibility">1:"Low", 2:"Medium", 3:"High"</option>

Your help would be much appreciated. Thanks

tshah-splunk — Wed, 13 Apr 2022 10:54:47 GMT

I don't think it is possible to change the labels on the Y-axis in any of the graph charts. Also, the charting.axisTitleY.visibility is to set if the title of the Y-axis should be visible or not. You can find information related to the parameter here - https://docs.splunk.com/Documentation/Splunk/8.2.6/Viz/ChartConfigurationReference#:~:text=charting.axisTitleY.visibility

You can transpose the data from Y-Axis to X-Axis and then use case conditions to change the mapping of the Alert_level.

faisalchohan — Tue, 26 Apr 2022 01:17:32 GMT

I really appreciated your response.

I have transpose the axis but it's the same result but showing on different axis.

Are you able to share some example?

Thanks