topic Re: Alpha based y axis in Splunk Search

Alpha based y axis

koreanfather — Wed, 15 Jul 2020 13:26:11 GMT

Hello I'm new to splunk and was wondering if there is a way where the values on the y axis can be non numeric.

I'm trying to create a chart that maps classroom grades so y axis needs to be abcdf.

I was able to translate the grade to a number and then chart it but I was curious to see if there was a possible alternative

Re: Alpha based y axis

niketn — Wed, 15 Jul 2020 14:27:50 GMT

@koreanfather can you add a mockup of what kind of output you are looking for? It can be whiteboard or sketch as well. The y-axis value (numeric) is used to plot the height of column or line chart. If you do not have the value how would you plot the height?

Re: Alpha based y axis

koreanfather — Wed, 15 Jul 2020 22:01:54 GMT

@niketn

Apologies for the crude drawing but the desired output is a chart with X axis being students names and y axis being the grades.

As for the height of the chart, I was able to solve the problem by setting y axis to originally map to A=5,B=4,C=3,D=2,F=1.

My curiosity was if it its possible to change the value of the y axis on a cosmetic level

Thank You

Re: Alpha based y axis

niketn — Fri, 17 Jul 2020 02:09:12 GMT

@koreanfather I did have an answer to add % or same prefix/suffix on y-axis. However, this seems like a data mapping based replacement of y-axis, which is indeed a difficult challenge to implement. I can try to have a look in some spare time 🙂 But see if you can use the following answer along with Data parsing through Custom cell renderer to solve your issue: https://community.splunk.com/t5/Splunk-Search/How-to-change-the-Y-axis-label-on-a-chart-overlay/td-p/390762

Could you add details on what is there on x-axis so that we can see if there is an alternate visualization for your needs?