Dashboards & Visualizations

single value chart showing lastest weekly count and delta from max in the last 30 days

mfadmin
New Member

We import vulnerability scan data into splunk on a weekly basis and report back in a trellis'd timechart dashboard. We use tokens to set criteria like segment, risk, and vulnerability type to produce timecharts of each of the count of named vulnerabilities over the last 30 days. Execs want (of course) red, yellow and green single value of current count and movement from the max count day of the last 30 by Name of Vulnerability. Experimented with stats using max(count) unsuccessfully. Here is the functional bits of my search that don't involve all of the qualification I do against known risk accepted or the criteria. What do I need to turn this into single value chart(s) with the latest count and the delta from the max daily entry in the last 30 days?

index=nessus | dedup _time,extracted_Host,Name | table _time,Name| timechart cont=FALSE count(extracted_Host) by Name

Tags (1)
0 Karma

renjith_nair
Legend

@mfadmin,
Are you looking for something like this ?

index=_*|timechart count|eventstats max(count) as max|eval diff=max-count|table _time,diff
---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...