Calculate Mean and Median

Frank Caruso shared this question ago

Completed

Working with the following data:

/bd9bd37f8fbbb8a60a8329f7d02f2dc4

I would like to use mean and median. I add the same days open calculated field and apply the advanced function for median an d I get the following:

/eaec2fd849ed3510c78a45aa8cd1aff3

The median calculation for Critical and High tickets is correct but I only want it to appear once for each priority. Is this possilbe?

Thank you

Replies (1)

Diego Gabanzo ●

HI Frank,

Thanks for reaching out. I'd recommend reaching out to BMC for support with this -

due to the highly customized environment with special calculations etc.

Thanks,

Eric

Reply URL