Splunk Search

## Percentage correct utilization formula

Path Finder

I have a search which gives me a list of calls.
Whereby taking only business days and hours in a week- I need to take out utilization for each number.

Thanks

Tags (4)
1 Solution SplunkTrust

Yes it is...

you can try it with fake values, for example:

``````| makeresults count=1
| eval active = 20
| eval inactive = 30
| eval utilization=round(active/(active+inactive)*100,2). "%"
``````

play with the numbers, or use random function:

``````| makeresults count=1
| eval active = random()%200
| eval inactive = random()%300
| eval utilization=round(active/(active+inactive)*100,2). "%"
``````

hope it helps SplunkTrust

Yes it is...

you can try it with fake values, for example:

``````| makeresults count=1
| eval active = 20
| eval inactive = 30
| eval utilization=round(active/(active+inactive)*100,2). "%"
``````

play with the numbers, or use random function:

``````| makeresults count=1
| eval active = random()%200
| eval inactive = random()%300
| eval utilization=round(active/(active+inactive)*100,2). "%"
``````

hope it helps  