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

0 Karma
1 Solution

SplunkTrust
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

View solution in original post

0 Karma

SplunkTrust
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

View solution in original post

0 Karma