Splunk Search

How to show non number values on y axis on a chart

matansocher
Contributor

I have the following search and I would like to present instead of the 40 dummy values, the actual name of the field Report_Milestone.

the code I am using:

| inputcsv MilestonesCSV 
| dedup Report_Milestone 
| fieldformat TaskDeadline = strftime(TaskDeadline, "%d/%m/%Y") 
| eval milestoneNumber = 1
| eval Day1ofWeek = strftime(relative_time(TaskDeadline,"@w0"),"%d/%m/%y")
| table TaskDeadline Report_Milestone milestoneNumber Day1ofWeek
| chart sum(milestoneNumber) over Day1ofWeek by Report_Milestone

The chart output:
alt text

The y axis expects to see only number values, and instead of the 40 values, I would like to see the values on the left - the names ("Report_Milestone1").

0 Karma

woodcock
Esteemed Legend

DalJeanis
Legend

The quickest thing I would try is, change to this...

 | chart count over Day1ofWeek by Report_Milestone

...and switch the display format to show multiple independent series. That way you get one chart per report milestone, with one data point per milestone across the time in question.

It feels like chart is not the right tool for this, though I don't know offhand what the right one would be for displaying single, independently labeled events.

0 Karma
Get Updates on the Splunk Community!

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...