New Array: For Fractile Function

[#1]

Hi All,

In my tables that i loaded, I had to use left join to get rid of loops. The result, a crosstable where the new fields from the tables that were joined have been defined. I've said this to set some context around what my data looks like.

Before the join i used FRACTILE(AnnualFixedCTC,0.25) to give me the 1st Quartile and it worked perfectly. With my new 'TABLE'  it is not giving me the correct value. This is because my range is now 'larger' due to duplicate 'values' because of the joins.

My question Is there anything I can do to limit/define my range for my fractile function. The fractile function dimension is OCCUPATION, encase you need that. I tried using my limited knowledge of aggr and set analysis with no such luck yet.

Thanks,
Byron

[danielrozental · Accepted solution]

Byron,

You can try something like this

FRACTILE(aggr(AnnualFixedCTC,OCCUPATION),0.25)

Beware that it will probably not have amazing performance.

[#3]

Thanks Daniel. Looks so easy when shown the way All I had to change was occupation to employeeno, since the table already had occupation as a dimension. Thanks a lot Daniel

Cheers,

Byron