Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list of responses and I want the median value, which I assumed could be achieved with median(Response_%), however I get the incorrect value
The only thing I can think is affecting this, is that there are 2 duplicate values in the response_% column, but I need the median of the full set of responses
Thanks in advance
Sophie
Does that duplicate value actually appear twice in your data? Or is a single value linked to by two InterviewId? You show 19 rows in your table chart. Are there actually 19 Response_% values or 18?
-Rob
Yes it appears twice
The table is the total sales for 19 different salespeople, so I would like the median sales value. All interviewID_%s are unique to each salesperson.
When I select all 19 Response_%s it says 17 selected (2 duplicates)
Thanks
Sophie
*Update*
I manage to get the correct value if I use: median(aggr(only(Response_%), Response_%)) if anyone else that issue!
Thanks
Sophie