Reporting on Median Time To Remediate using PA indicator?

[GRACHELLE ILANO]

In Vulnerability Response OOB there's Mean Time To Remediate formula indicator calculated as Summed duration of VI / Total Count of VI. PA Aggregate options only include Sum, Count, Minimum, Maximum but no Median.

Looking for a less complicated way to calculate the Median score for a set of durations/age?

[AndersBGS]

Hi @GRACHELLE ILANO ,

I do not think that you will find a more simplistic way of calculation the median. The mean (informally, the “average“) is found by adding all of the numbers together and dividing by the number of items in the set. So basically in PA you need to formula indicators where the formula is stored in the formula indicator.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[GRACHELLE ILANO]

Hi,

Yes of course it would be through formula indicators. I can get the number of items in the set using Aggregate 'Count' in an Automated Indicator. I'm not sure how to get the all the numbers (no addition or anything) in ascending order through an indicator like I'd normally would in an array? Do you have a suggested way to go about that?

[AndersBGS]

Hi @GRACHELLE ILANO ,

I didn't understand your comment? Is it the duration that you're missing? Or something else ?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[GRACHELLE ILANO]

I'm looking for a way to get all the durations without having to add them up since I want to calculate the 'median' and not the 'mean or average'.

ex:

n = [10 days, 5 days ,2.5 days, 4 days] -> this is what I need

for an even numbered array or skewed distribution the calculation for the median would be ((n/2)th term + ((n/2) + 1)th term)/2