[Mondrian] Percentile() function

Matt Campbell mcampbell at pentaho.com
Tue Aug 6 14:08:17 EDT 2013


Try 50 and 75 for the 3rd parameter of Percentile, instead of .50 and .75.


On 08/06/2013 01:11 PM, Kleyson Rios wrote:
I am trying to use Percentile function in the following way:

member [Measures].[Median] as 'Median([Ano].[Ano].Members, [Measures].[Incidencia])'
member [Measures].[ThirdQ] as 'ThirdQ([Ano].[Ano].Members, [Measures].[Incidencia])'
member [Measures].[Percentile50] as 'Percentile([Ano].[Ano].Members, [Measures].[Incidencia], 0.50)'
member [Measures].[Percentile75] as 'Percentile([Ano].[Ano].Members, [Measures].[Incidencia], 0.75)'

select

NON EMPTY {[Measures].[Median], [Measures].[Percentile50], [Measures].[ThirdQ], [Measures].[Percentile75]} ON COLUMNS,
NON EMPTY {[Semana].[Semana].Members} ON ROWS

It was supposed Median == Percentile50 and ThirdQ == Percentile75, right ?

But I am getting different values, like:

Semana               Median                Percentile50      ThirdQ                  Percentile75
1                             8,210334              0,151375              16,119757           0,227063
2                             16,494635           2,175962              22,855360           2,239248
3                             19,793562           2,447579              33,987053           2,553519
4                             23,139128           1,733540              40,587217           1,948231
5                             24,826356           1,895903              40,814809           2,191776
6                             29,239905           2,461290              44,532143           2,806971


Am I doing something wrong or it could be a bug ?

Regards.

--
Kleyson Rios
Gestor de TI
Coordenador de BI / Banco de Dados
Gerência de Tecnologia da Informação
Secretaria de Estado da Saúde de Goiás
(62) 3201-3707

Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130806/932581ad/attachment.html 


More information about the Mondrian mailing list