How have you used basic and advanced functions (in calculated metrics)?

[Community user]

I'm referring to functions like percentile, count, Linear regression: Correlation coefficient, etc.

What kind of questions can you answer, and specifically which reports would you apply them to?