Calculate Mean and Median

Frank Caruso shared this question 21 months 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 (3)

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

photo
1

Many thanks. If you need help with this, I suggest contacting BMC: http://www.bmc.com/support/support-central.htmldordle When I attempted to change the Format to Date, the whole column was wiped clean.

photo
1

The information you share is great, please continue to write about this topic regularly https://community.yellowfinbi.com/topic/calculate-mean-and-median#flagle

Leave a Comment
 
Attach a file