Divide a severity count by host count in a timechart

[jravida]

Hi folks,

I guess what I am trying to do is create a timechart based on a scan events severity rating(low, med, high, severe):

index=scan | timechart span=1mon count by severity

I have another query, which gives me a timechart of the total number of hosts that were actually scanned month to month:

index = scan | timechart span=1mon dc(hostName)

Since the total number of each severity means nothing without the host count as context, I would like to divide the total count of each severity by the host count, month to month (each will be different). I've tried to join the search, but haven't had any luck dividing the severity counts by the host count in the timechart or stats command.

Thanks!

[jkat54]

 index=scan | timechart span=1mon dc(hostName) by severity

[jravida]

This does the 'split by' function. I need the dc(hostName) month by month, to divide the number of severities, by severity