Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Customer segmenting measure not showing all values.

Hello,   I am having an issue where I have a matrix tables, with names in the rows and months in the columns, and values being a measurable called 'samples'. On another page of my report, I have co...
Need Help
changqing's avatar
changqing
Icon for Resolver II rankResolver II
3 years ago

Hi Anonymous ,

 

Not sure, this is my first exposure to the PERCENTILEX.inc function. When I looked at an example of it, I guessed that the reason it might be waiting is that it comes up with values that are not in the table parameters.

For example, the above percentilex. INC 0.75 returns 2.5, but this value is not in the raw table.

 

PERCENTILEX.INC

 

regards

CQ

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi changqing,

     

    I am not using PERCENTILEX.inc function to get a percentile of samples though. I am using the function to summarise customers based on samples, splitting them into percentile groups based on each customers ID.

     

    Given this, none of the expected results would be in the original table I would think.

     

    The returned result is not the result of the percentile function but should show the number of samples for each customer within the percentage group.