СÊýÊý×Ö
²Ù×÷
ʹÄúÄܹ»¼ÆËãÖ¸¶¨×ֶεļÓȨƽ¾ùÖµ¡£ÔÚ¼ÆËã¼ÓȨƽ¾ùֵʱ£¬Êµ¼ÊÉÏÊǼÆËãÒ»¸ö×Ö¶ÎµÄÆ½¾ùÖµ£¬È»ºóʹÓÃÁíÒ»¸ö×ֶεÄÖµÀ´¶ÔµÚÒ»¸ö×Ö¶ÎÖеÄÿ¸öÖµÔÚÆ½¾ùÖµÖеÄ×÷ÓýøÐС°¼ÓȨ¡±¡£ÔÚÒ»°ãµÄƽ¾ùÖµÖУ¬ËùÓÐȨÊý¶¼µÈÓÚ 1¡£ ÀýÈ磺
? ? ?
Äú¿ÉÒÔ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£
Äú¿ÉÒÔ¶Ôij¸ö×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÀ´×ÔµÄÊ¡½øÐзÖ×飩µÄËùÓÐÖµ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£
Äú¿ÉÒÔ¶ÔÆä·Ö×éÓÉÈÕÆÚ»ò²¼¶û×Ö¶ÎÖеı仯½øÐпØÖƵÄ×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÍê³ÉµÄÔ·ݽøÐзÖ×飩ÖеÄËùÓÐÖµ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£
ʾÀý
ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º
WeightedAverage({table.FIELD1}, {table.FIELD2})
·µ»Ø 3.5£¬ÆäÖÐÁ½¸ö×Ö¶ÎÖÐÿ¸ö×ֶζ¼ÓÐËĸöÖµ¡£Field1 ¾ßÓÐÖµ 3¡¢2¡¢5 ºÍ 1¡£Field2 ¾ßÓÐÖµ 0¡¢1¡¢1 ºÍ 0¡£WeightedAverage ¼ÆËãÈçÏ£º(3*0 + 2*1 + 5*1 + 1*0)/sum{table.FIELD2}) = 3.5¡£
×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£
Median
Basic Óï·¨ºÍ Crystal Óï·¨¡£
ÖØÔØ
? ? ?
²ÎÊý
Median (fld) Median (fld, condFld) Median (fld, condFld, cond)
? ?
fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÓÐЧµÄÊý¾Ý¿â×ֶλò¹«Ê½×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£
? cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£
·µ»Ø
СÊýÊý×Ö
²Ù×÷
¼ÆËã¸ø¶¨ÊýÖµ×ֶεÄÖÐÖµ¡£ÖÐÖµÊÇÖ¸Ò»¸öÊýÖµÐòÁÐÖеÄÖмäÖµ£¨»òÕßÊÇÒ»¸öżÊýÐòÁÐÖµÖÐÁ½¸öÖмäÖµµÄƽ¾ùÖµ£©¡£ ÀýÈ磺
? ? ?
ʾÀý
Äú¿ÉÒÔ¼ÆËãij¸ö×Ö¶ÎÖÐËùÓÐÖµµÄÖÐÖµ¡£
Äú¿ÉÒÔ¼ÆËãij¸ö×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÀ´×ÔµÄÊ¡½øÐзÖ×飩µÄÒ»¸ö×Ö¶ÎÖÐËùÓÐÖµµÄÖÐÖµ¡£
Äú¿ÉÒÔ¼ÆËãÆä·Ö×éÓÉÈÕÆÚ»ò²¼¶û×Ö¶ÎÖеı仯½øÐпØÖƵÄ×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÍê³ÉµÄÔ·ݽøÐзÖ×飩ÄÚËùÓÐÖµµÄÖÐÖµ¡£
ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º
Median({¿Í»§.È¥ÄêÏúÊÛ¶î})
·µ»Ø $29087£¬ÆäÖС°È¥ÄêÏúÊ۶×ֶεÄֵΪ $27014¡¢$28000¡¢$29087¡¢$34500 ºÍ $48260¡£
Median({¿Í»§.È¥ÄêÏúÊÛ¶î}, {¿Í»§.µØÇø)
¶Ô¡°È¥ÄêÏúÊ۶×ֶΰ´µØÇø½øÐзÖ×飬²¢·µ»ØÃ¿¸öµØÇø¡°È¥ÄêÏúÊ۶×ֶεÄÖÐÖµ¡£
Median({¶©µ¥.¶©µ¥½ð¶î}, {¿Í»§.µØÇø}, \
¶Ô¡°½ð¶î¡±×Ö¶ÎÖеÄÖµ°´µØÇø½øÐзÖ×飬Ȼºó·µ»ØÃ¿ÔÂÖÐÿ¸öµØÇø¶©µ¥½ð¶îµÄÖÐÖµ¡£
×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£
ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£ PthPercentile
Basic Óï·¨ºÍ Crystal Óï·¨¡£
ÖØÔØ
? ? ?
²ÎÊý
PthPercentile (P, fld) PthPercentile (P, fld, condFld) PthPercentile (P, fld, condFld, cond)
? ? ? ?
P ÊǽéÓÚ 0 ºÍ 100 Ö®¼äµÄÈκÎÕûÊý¡£ fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÊý×Ö×ֶλò»õ±Ò×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£
cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£ Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£
·µ»Ø
Êý×Ö»ò»õ±ÒÖµ
²Ù×÷
¼ÆËãÊý×Ö×ֶλò»õ±Ò×Ö¶ÎÖÐÖ¸¶¨°Ù·Öλ (P) µÄÖµ¡£
ʾÀý
ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º
PthPercentile(20, {¿Í»§.È¥ÄêÏúÊÛ¶î})
·µ»Ø $2302 ×÷ΪµÚ 20 ¸ö°Ù·ÖλµÄÖµ£¨Èç¹û {¿Í»§.È¥ÄêÏúÊÛ¶î} µÄ 20% СÓÚ $2302£©¡£
PthPercentile(P, {¿Í»§.È¥ÄêÏúÊÛ¶î}, {¿Í»§.µØÇø})
¶Ô¡°È¥ÄêÏúÊ۶×ֶΰ´µØÇø½øÐзÖ×飬²¢·µ»ØÃ¿¸öµØÇø¡°È¥ÄêÏúÊ۶×Ö¶ÎÖаٷÖλ P Öµ¡£
PthPercentile(P,{¶©µ¥.¶©µ¥½ð¶î}, {¿Í»§.µØÇø}, \
¶Ô¡°½ð¶î¡±×Ö¶ÎÖеÄÖµ°´µØÇø½øÐзÖ×飬Ȼºó·µ»ØÃ¿ÔÂÿ¸öµØÇøµÄ¡°½ð¶î¡±×ֶεİٷÖλ P Öµ¡£
×¢ÊÍ
µ± P = 50£¨µÚ 50 ¸ö°Ù·Öλ£©Ê±·µ»ØµÄÖµÓë Median º¯Êý£¨ÖÐÖµ£©·µ»ØµÄÖµÏàͬ¡£
×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£
ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£ NthLargest
Basic Óï·¨ºÍ Crystal Óï·¨¡£
ÖØÔØ
? ? ?
²ÎÊý
NthLargest (N, fld) NthLargest (N, fld, condFld) NthLargest (N, fld, condFld, cond)
? ? ? ?
N ÊÇ´Ó 1 µ½ 100 Ö®¼ä£¨°üÀ¨ 1 ºÍ 100£©µÄÈκÎÕûÊý¡£ fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÓÐЧµÄÊý¾Ý¿â×ֶλò¹«Ê½×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£
cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£
·µ»Ø
СÊýÊý×Ö
²Ù×÷
È·¶¨Õû¸ö±¨±í»òÿ¸ö (condFld) ×éʵÀýÖиø¶¨×Ö¶ÎµÄµÚ N ¸ö×î´óÖµ¡£
ʾÀý
ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º
NthLargest(1, {¿Í»§.¿Í»§ ID}
·µ»Ø 50£¬ÆäÖС°¿Í»§ ID¡±×ֶΰüº¬·¶Î§´Ó 12 µ½ 50 µÄÊýÖµ¡£
NthLargest(5, {¿Í»§.¿Í»§ÐÕÃû}, {¿Í»§.µØÇø})
·µ»ØÃ¿¸öµØÇøÖС±¿Í»§Ãû³Æ¡±×Ö¶ÎµÄµÚ 5 ¸ö×î´óÖµ¡£