Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Dashboards & Visualizations
- :
- Can we plot string values in a graph?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have three columns in stats.
1. Date
2. Number
3. String Value (ABCDEF)
Once i create a chart over "Date " , how can I also show the corresponding "string value" in the graph?
Since line\Area graph will only consider numerical values, it doesn't show the 3rd field values.
I am expecting to have Date in X axis and Number in Y Axis. Can anyone help?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps you are looking or xyseries.
I ran a query on the default _audit index so that you can use the code to run as it is. Try the below:
index="_audit" | stats count by _time,action
The above code gives you _time,action and count as columns in the statistics output.
Now, try this :
index="_audit" | stats count by _time,action | xyseries _time,action,count
See the visualization tab, this is perhaps what you want. Replace your fields to map accordingly, basically the below, if the above result is what you want-
Date - _time
Number - count
action - string
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps you are looking or xyseries.
I ran a query on the default _audit index so that you can use the code to run as it is. Try the below:
index="_audit" | stats count by _time,action
The above code gives you _time,action and count as columns in the statistics output.
Now, try this :
index="_audit" | stats count by _time,action | xyseries _time,action,count
See the visualization tab, this is perhaps what you want. Replace your fields to map accordingly, basically the below, if the above result is what you want-
Date - _time
Number - count
action - string
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is exactly what i was looking for. Thank you so much!!
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Make Your Machine Data AI-Ready in Splunk
Splunk Asynchronous Forwarding Explained
How to Monitor AI Agents with Splunk Agent Observability
