Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there folks .. here's another question ..
I have a COLUMN_A with values that are COUNT (DISTINCT Field#1)
in COLUMN_B .. I wanna compare each value in COLUMN_B with the lowest Quartile figure of the stack of numbers in COLUMN_A
I assume the first thing I need to do is to GET that lowest Quartile figure .. but for the life of me I can't get the "fractile" function to work ..
.. my latest try is .. =FRACTILE(Aggr(Count(Distinct Field#1)),0.25) which is most likely wrong as it is not working for me .. Thoughts?
Thx
What is your chart dimension here?
Ah .. no worries mate.. got that resolved today. Sorry for not giving enough info in my question. I really appreciate your quick response.