Splunk Search

Alpha based y axis

koreanfather
Observer

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

Labels (1)
0 Karma

niketn
Legend

@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?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

koreanfather
Observer

temp.PNG

@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

0 Karma

niketn
Legend

@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...

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?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more with ITSI’s ...

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more! Faster Time to ValueManaging and ...

New Release | Splunk Enterprise 9.3

Admins and Analyst can benefit from:  Seamlessly route data to your local file system to save on storage ...

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...