I'm trying to find the 90th percentile value for "first reply time" and was able to follow the steps on Amy Dee's comment in this thread. However, the percent rank function seems to break once there are blank or zero values. The increments for the percentiles are correct, but all blank values are assigned 0th percentile. I had the same issue when I attempted substituting zeros for the blanks (this is the last column - it got cut off).
I checked with Excel to verify, with Excel's calculation to the far right.
Is there a workaround I'm missing, or is this a product of how the function works? I'd like to be able to find percentiles within Explore if at all possible.
This post has been moved to the Explore Q&A topic by the Zendesk Community Team
Please sign in to leave a comment.