What is the average of occurrence of string in the log files?

[tankhanandita]

Hi,

I have a log file in which I have two things

functionality and different repositories which use this functionality . I want to calculate average of occurrence of this functionality over each repository. 

The name of the functionality is string

Repo 1 A,A,A

Repo 2 A,A,A

Repo 3 A,A,A,A

The output should be

Name of Repo Avg for functionality A

1                               0.3

2                                0.3

3                                0.4

[ITWhisperer · Accepted solution]

Assuming you have a field called string holding the string you want counting and a field called repo holding the repository name, try something like this

| stats count by repo string
| eventstats sum(count) as total by string
| eval average=round(count/total,2)
| xyseries repo string average

[tankhanandita]

Hi,

Thank you so much! This worked