### window.median

Supported in:

    window.median(numeric_values, should_ignore_zero_values)

#### Description

Return the median of the input values. If there are 2 median values, only 1 will be non-deterministically chosen as the return value.

#### Param data types

`INT|FLOAT`, `BOOL`

#### Return type

`FLOAT`

#### Code samples

##### Example 1

This example returns the median when the input values aren't zero.

    rule median_file_size {
        meta:
        events:
          $e.metadata.event_type = "FILE_COPY"
            $userid = $e.principal.user.userid
        match:
          $userid over 1h
        outcome:
          $median_file_size = window.median($e.principal.file.size) // returns 2 if the file sizes in the match window are [1, 2, 3]
      condition:
          $e
    }

##### Example 2

This example returns the median when the input includes some zero values that shouldn't be ignored.

    rule median_file_size {
        meta:
        events:
          $e.metadata.event_type = "FILE_COPY"
            $userid = $e.principal.user.userid
        match:
          $userid over 1h
        outcome:
          $median_file_size = window.median($e.principal.file.size) // returns 1 if the file sizes in the match window are [0,0, 1, 2, 3]
      condition:
          $e
    }

##### Example 3

This example returns the median when the input includes some zero values which should be ignored.

    rule median_file_size {
        meta:
        events:
          $e.metadata.event_type = "FILE_COPY"
            $userid = $e.principal.user.userid
        match:
          $userid over 1h
        outcome:
          $median_file_size = window.median($e.principal.file.size, true) // returns 2 if the file sizes in the match window are [0,0, 1, 2, 3]
      condition:
          $e
    }

##### Example 4

This example returns the median when the input includes all zero values which should be ignored.

    rule median_file_size {
        meta:
        events:
          $e.metadata.event_type = "FILE_COPY"
            $userid = $e.principal.user.userid
        match:
          $userid over 1h
        outcome:
          $median_file_size = window.median($e.principal.file.size) // returns 0 if the file sizes in the match window are [0,0]
      condition:
          $e
    }

##### Example 5

This example shows that, when there are multiple medians, only one median is returned.

    rule median_file_size {
        meta:
        events:
          $e.metadata.event_type = "FILE_COPY"
            $userid = $e.principal.user.userid
        match:
          $userid over 1h
        outcome:
          $median_file_size = window.median($e.principal.file.size) // returns 1 if the file sizes in the match window are [1, 2, 3, 4]
      condition:
          $e
    }