Percentage correct utilization formula

[splunkuseradmin]

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

[adonio · Accepted solution]

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