[Mondrian] RES: Percentile() function

Paul Stoellberger p.stoellberger at gmail.com
Wed Aug 7 06:20:13 EDT 2013


What version of mondrian are you using?
There used to be a bug that would return negative values in some cases


On Aug 6, 2013, at 8:47 PM, Kleyson Rios wrote:

> Now Trying:
>  
> 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], 50)'
> member [Measures].[Percentile75] as 'Percentile([Ano].[Ano].Members, [Measures].[Incidencia], 75)'
>  
> And Getting:
>  
> Semana               Median                Percentile50      ThirdQ                  Percentile75
> 1                             8,210334              8,210334              16,119757           -70,457817
> 2                             16,494635           16,494635           22,855360           -747,925440
> 3                             19,793562           19,793562           33,987053           -129,299646
> 4                             23,139128           23,139128           40,587217           -1125,307673
> 5                             24,826356           24,826356           40,814809           -3227,370688
> 6                             29,239905           29,239905           44,532143           -1849,499531
>  
>  
> Now Percentile50 is correct but Percentile75 not.
>  
> 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)
>  
> De: Matt Campbell [mailto:mcampbell at pentaho.com] 
> Enviada em: terça-feira, 6 de agosto de 2013 15:08
> Para: Mondrian developer mailing list
> Cc: Kleyson Rios
> Assunto: Re: [Mondrian] Percentile() function
>  
> 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)
>  
>  
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130807/8c19af9d/attachment-0001.html 


More information about the Mondrian mailing list