[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