percentile in the querie

[Andrej]

Hi
I found the code to calculate percentile value and It works fine,
my problem is that code is calculating value for the whole data set, not for the filtered data.
PercentileRst («RstName»; «fldName»; «PercentileValue»)
is it possible to put some function that can filter or sort data like it do access queries for the mean calculation
for example:
dp1 100
dp1 90
...
dp2 89
dp2 78
...
percentile value for dp1, dp2....

thx in advance

 

[KenHigg]

This is just a guess - Can you do a second query based on the first to do the percentile calculation in?

 

[Andrej]

on beginning it was my idea too

It's possible, but is not useful
I have to do 140 queries to do that work
but thanks anyway

 

[KenHigg]

Zowie. Sounds like you may have normalization issues...


ken

 

[Andrej]

in a way, is a lot's of ecological data that needs to have a value of percentile and g. mean and then it's all connect to ArcMap to present that on GIS maps.
is it possible to put function in the function like:

PercentileRst («RstName»; Sort by other column «fldName»; «PercentileValue»)