Calculate Mean and Median

Frank Caruso shared this question 28 days ago
Answered

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

Comments (1)

photo
1

HI Frank,

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

http://www.bmc.com/support/support-central.html

due to the highly customized environment with special calculations etc.


Thanks,

Eric