Dashboards & Visualizations

changing labels on a chart (will be numeric to string)

ChrisCLewis
Communicator

I have a query that produces a lovely table
base search |chart values(Number) as State over Date by description

Date | act1 | act2 | act3
M05 | 1 _ .... | -1_ .... | 3....
M06 | 5 _ .... | -1_ .... | 3....
M07 | 5 _ .... | -1_ .... | 4....
M08 | 5 _ .... | -1_ .... | 4....

Each of the numbers under the actions relate to a state of play (not started, in progress etc).
I can create all sorts of graphs off this data but I have been asked to change the number scale to description of the action
I can change Numbers to Description to get the following data but I can only create tables from it (stats and chart needing numeric values)

Date | act1 | act2 | act3
M05 | NS_ | NA_ | IP_
M06 | Co_ | NA_ | IP_
M07 | Co_ | NA_ | IP_
M08 | Co_ | NA_ | Re_

Is there a way to change number value to a string on the axis once the chart has been completed.
Happy to go with css if can't be done in xml.

Many thanks

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...