Solved: Calculating Percentage

vinod743374 · ‎07-12-2021

i just want to calculate the Passed Percentage of every date .

i have the Passed Count as well as the Total devices.

is there any logic to calculate the % for every date Dynamically , because there are few more data to be added with a different date.

Please help me , is there any possibility to do that .

it would be appreciated,
Thank you.

richgalloway · ‎07-12-2021

Try foreach. It iterates over fields that match a pattern and performs specified commands on each.

| foreach Passed* [eval "Pct<<MATCHSTR>>" = '<<FIELD>>'*100/'Total<<MATCHSTR>>'

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway · ‎07-12-2021

Try foreach. It iterates over fields that match a pattern and performs specified commands on each.

| foreach Passed* [eval "Pct<<MATCHSTR>>" = '<<FIELD>>'*100/'Total<<MATCHSTR>>'

---
If this reply helps you, Karma would be appreciated.

Calculating Percentage

count

eval

transaction

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.

Best Practices: Splunk auto adjust pipeline queue

Introducing the 2026 - 2027 SplunkTrust cohort!

Splunk Auto Ingestion Parallel Pipeline Scaling

Join the Conversation