Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Timechart with multiple fields and calculating per...
- 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
My query is something like
.. | eval color_and_shape = color + "/" + shape
| timechart count as total, count(eval(heavy="true")) as heavy by color_and_shape
which returns a table similar to
_time heavy:green/triangle heavy:green/circle total:green/triangle total:green/circle
11/20/12 1 2 5 6
How would I go about calculating the percentage of shapes that a heavy by color_and_shape?
I tried doing ...| eval pct=sc/total
but this does not work.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The problem is that after you've run the results through timechart, you no longer know all the combinations of column headers you'll need to calculate the percentage.
A better way of approaching this would be to work out the percentages before running timechart like this :
... | eval color_and_shape = color + "/" + shape
| bin _time span=1d
| stats count as total, count(eval(heavy="true")) as heavy by color_and_shape _time
| eval perc_heavy=100*heavy/total
Then you can do the timechart
... | timechart span=1d first(total) as total first(heavy) as heavy first(perc_heavy) as perc_heavy by color_and_shape
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The problem is that after you've run the results through timechart, you no longer know all the combinations of column headers you'll need to calculate the percentage.
A better way of approaching this would be to work out the percentages before running timechart like this :
... | eval color_and_shape = color + "/" + shape
| bin _time span=1d
| stats count as total, count(eval(heavy="true")) as heavy by color_and_shape _time
| eval perc_heavy=100*heavy/total
Then you can do the timechart
... | timechart span=1d first(total) as total first(heavy) as heavy first(perc_heavy) as perc_heavy by color_and_shape
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.
Announcing Modern Navigation: A New Era of Splunk User Experience
Modernize your Splunk Apps – Introducing Python 3.13 in Splunk
Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...
